Power BI Desktop: Introduction (2 hr)
Introduction to business intelligence Introduction to data analysis Introduction to data visualization Overview of self-service BI Considerations of self-service BI Microsoft tools for self-service BI Power BI vs. SSRS Report Installation – Power BI Desktop Configure tools
Getting and Shaping Data (3 hr)
Using databases as a Power BI data source SQL Server Database Microsoft Access Database
Using Excel as a Power BI data source Using databases as a Power BI data source The Power BI service Import data into Power BI Data Clean up Transforming Data Append Operation Merge Operations Lab : Import data into Power BI Data Clean up Transforming Data Append Operation Merge Operations
M Language: (2 hr)
The Power Query M formula language is optimized for building highly flexible data mashup queries. It's a functional, case sensitive language similar to F#. Power Query statements are made up of individual language elements such as functions, variables, expressions, and primitive and structured values that together define the logic necessary to shape the data. In this module, we will share Power BI Model (3 hr)
Enhancing Power BI Model (3 hrs)
Data Flows (1 hr)
Here-in the data will be uploaded to Power BI Service, and different visualizations /reports will be created, and Visualizing (3hrs)
Security (1 hr)
Data Storage Security Row Level Security Demo: Security
Refreshing Data (2 hrs)
Publishing DataSets Refreshing Data Power BI Mobile Apps Using Power BI Gateway - Personal Understanding Power BI Gateway – Enterprise Power BI Pro vs. Free Publishing To Power BI Setting Up Auto-Refresh Content Packs Sharing Within the team /with organization Creating Dashboards Sharing Reports /Dashboards
DAX Introducing DAX (1 hr) Understanding DAX Calculations Understanding Calculated Columns And Measures Variables Handling Errors In DAX Expressions Formatting DAX Code Common DAX Functions
Using Basic Table Functions (2 hrs) Introducing Table Functions Evaluate Syntax Using Table Expressions Understanding Filter Understanding All, Allexcept, And Allnoblankrow UNDERSTANDING VALUES AND DISTINCT
Understanding Evaluation Contexts (2 hrs) Introduction To Evaluation Contexts Testing Your Evaluation Context Understanding Creating A Row Context With Iterators Understanding Filter, All, And Context Interactions Working With Many Tables Evaluation Contexts Recap Creating A Parameter Table
Understanding CALCULATE And CALCULATETABLE (2 hrs) Understanding Calculate Calculate Examples Understanding Context Transition Variables And Evaluation Contexts Understanding Circular Dependencies Calculate Rules Introducing Allselected
DAX Examples (2 hrs)
Computing Ratios And Percentages Computing Cumulative Totals
Optimizing Data Models and Strategy (1 hr) Gathering Information About The Data Model Denormalization Columns Cardinality Calculated Columns Choosing The Right Columns To Store Optimizing Column Storage
|