Introduction to the Power BI Environment April 2021

-

Course Description

Create stunning interactive reports and share amazing insights! Power BI gives Excel users the power to extract data from multiple sources, link it together, perform calculations and create powerful visualisations. Power BI is an AMAZING cloud-based business analytics service provided by Microsoft that allows users to transform data into rich, interactive visual reports that present a 360-degree business view and improve business decision making. Power BI Desktop is a development platform from Microsoft that allows users to connect to a huge range of data sources, clean and transform messy data, create relationships between data sets, perform calculations and prepare stunning interactive reports. Power BI.com allows users to publish their interactive reports and share certain features of those reports with others. Reports published to PowerBI.com can be set to refresh automatically and can be interacted with online using any browser or mobile device. This is module#1

Modules

  • Module 1: Introduction to the Power BI Environment
  • Module 2: Preparing Dashboard Data
  • Module 3: Creating Interactive Visualizations
  • Module 4: Using POWERBI.com to add value to your reports

Learning Outcomes

  • Import data into Power BI Desktop from a wide variety of data sources
  • How to join different data sets together, even if they come from different files, databases or other sources
  • Clean and transform your data so it’s ready for use with Power BI
  • Delve into “Get Data” and an introduction to understanding “M” code (Power Query language)
  • Turn short, wide data tables into long, tall tables and why this is so useful for Power BI
  • Join multiple data tables together and understanding relationships
  • Create efficient data models: merging, appending and structuring your datasets to create the optimal structure
  • Apply your Power Query skills to Excel and when to choose one over the other
  • Use different techniques for creating and utilising a Calendar table that you can use to slice and summarise your reports
  • Create queries that automatically report errors and missing codes
  • Automatically combine all the Excel, CSV or Text files in a folder into one table and see how you could apply this
  • Apply the principles of filter context, how critical this is for DAX formulas, and how to modify this in calculations to produce the results you need
  • Use DAX formulas work and how they’re different from Excel (even though they look similar!)
  • Determine when to use a calculated column in a table and when to write a measure
  • Create stunning interactive reports and share amazing insights! Power BI gives Excel users the power to extract data from multiple sources, link it together, perform calculations and create powerful visualisations.

Prerequisites

  • This is an introductory course and although it does not assume any prior experience with Power BI, participants will gain much more from the course if they have at least used Power BI a little prior to attending.  Participants who have taught themselves Power BI will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know.
  • A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential.

Who Should Attend

  • Excel users & analysts that focus on extracting, re-organizing and analyzing data
  • Anyone involved in creating visualizations & data modelling
  • Anyone interested in saving huge amounts of time in automating the work involved in creating recurring reports and dashboards

 

Event Date :

           Monday, April 5, 2021
           10:00 AM to 2:15 PM GMT+5:30

 

Details

Join here :
Join Here

Subscribe to our YouTube channel if you haven't:
Youtube

 

Comments

Post a Comment

Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You

Popular Posts

Failed to execute the package or element. Build errors were encountered

-
Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package
Read more

Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

-
TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) ------------------------------ ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: Exclusive access could not be obtained because the database is in use. (Microsoft.SqlServer.SmoExtended) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Procedure 1: 1. Right click Databases 2. Restore Database... 3. [General] Source from Device, select the bak file 4. [General] Change the Destination database name to a new name 5. [Files] Change mdf and ldf Restore As paths to a different, new path 6. [Options] (unnecessary on the other computer) Check Overwrite the existing database (WITH_REPLACE) 7. [Options] (unnecessary on the other computer)
Read more

Get List of logins on SQL Server instance

-
-- List of logins select sp . name as login ,        sp . type_desc as login_type ,        sp . type ,        sp . create_date ,        sp . modify_date ,        case                when sp . is_disabled = 1 then 'Disabled'             else 'Enabled'           end as status from sys . server_principals sp left join sys . sql_logins sl on sp . principal_id = sl . principal_id order by sp . name ;   --Get the list of all Login Accounts in a SQL Server SELECT name AS Login_Name , type_desc AS Account_Type FROM sys . server_principals WHERE TYPE IN ( 'U' , 'S' , 'G' ) and name not like '%##%' ORDER BY name , type_desc   --Get the list of all SQL Login Accounts only SELECT name , type_desc AS Account_Type FROM sys . server_principals WHERE TYPE = 'S' and name not like '%##%'   --Get the list of all Windows Login Accounts only
Read more