Microsoft Power BI - Innozant MIS & Data Analytics & Data Science
Administrator
Expert
Description
Master Power BI Desktop & learn Business Analytics
Power BI is a business analytics and visualization tool from Microsoft that helps professionals to present and visualize the data by bringing their data to life and tell more meaningful stories with the help of BI tool.
This course is a beginner guide for those professionals who aim to become confident in working with data, creating data visualizations, and preparing reports and dashboards. This course is perfect if you are :
- Beginner to Data Analytics
- Student, Academic
- Any analyst: Business Analyst, Marketing Analyst or Financial analyst
At the end of this course you will be able to analyse data from different data sources and create their own datasets. Able to comfortably work with the different tools of the Power BI universe and know how the different tools work together. Knowledge to dive deeper into Power BI and find out more about its advanced features.
What you will learn:
- Different tools of the MSPower BI universe and learn how to use them
- Understand Power BI Desktop and its components
- Working on real-time Data Set
- Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two steps
- Different views of the Data Model
- How to create calculated columns and measures
- How to build relationships between different tables
- DAX Functions
- How to create a report with different interactive visualization types
- Learn how to use Power BI Service (= Power BI Pro) to create dashboards and to share and publish your results
Topics for this course
108 Lessons44h 59m 59s
Training Duration : – 2.5 Months
Introduction to Power BI
Introduction to Power BI
- An Overview of the Workflow in Power BI Desktop
- Download and Installing Power BI Desktop
- Getting to know the Interface
- Power BI Free Vs. Pro Vs. Premium
- Power BI Key Components
- Introducing the Different Views of the Data Model
- Taking a Closer Look at the Query Editor Interface
Power BI Vs Excel Reporting
Power BI Vs Excel Reporting
- When we use which reports
Power BI overview Concept
Power BI overview Concept
- Dataset
- Reports
- Dashboard
- Workspace
- Tiles
Connecting Power BI Desktop to our Data Sources
Connecting Power BI Desktop to our Data Sources
- Excel
- CSV
- Web
- MS Access
- SQL Developer
- XML
- Connecting to a folder
- Others
Power Query
Power Query
- When to Use Power Query
- Import and analysis millions of Rows
- Best things to happen in Power BI: Type of Connection, Automate your data processing, Query Editor Tool, Pivoting and Un pivoting Columns, Duplicating Vs Referencing Queries, Transformations
- Editing Rows : First Header Row, Remove Top Rows, Filtering- Remove-Replace, Techniques
- Editing columns: Remove or Keep Columns, Navigation to the Columns, Change Columns Header Name
Understanding Append Queries
Understanding Append Queries
- Append Queries as existing (With two or multiple tables)
- Append Queries as New
- Formatting Data: Change data Type, Detect Data type for multiple columns, Remove error while loading, Remove null values, Splitting Columns, Delimiters, Delimiters positions Creating a New Group for our Queries
- Others : Sorting
- Performing Basic Mathematical Operations in Query Editor
- Improving Performance and Loading Data into the Data Model
- Columns distribution, Quality, Profile
Introducing the Star Schema
Introducing the Star Schema
- Fact Table Vs dim Table
- Star Schema | Dim Vs Fact Table
Joins
Joins
- Outer Join
- Left, Right, Full, Anti
- Inner join
Data Table Vs Lookup Table
Data Table Vs Lookup Table
- Primary key Vs, Foreign Key
- Relationship Vs. Merged Table
- Connecting Lookup to Lookups
- Relationship Cardinality
- Introducing and Understanding Relationships : One to One Relationship, One to Many Relationship
- Many to Many Relationship
- Bad Cardinality Many to Many
- Bad Cardinality One to One
- Importance for Filter Direction
- Editing Relationships
- Data Model Best Practice
Working on our Data Model Data Relationship View
Working on our Data Model Data Relationship View
- Query Editor vs. Data Model : Feature of Query Editor (Structure + Prepare Data), Data Model – Add Relationship, Add Measures (Analysis Data)
- Active properties
- Understanding the differences between the M-Language and DAX
- DAX – Basic information
- Calculated Columns vs. Measures
- Introducing DAX-Measures
- DAX-Measures
DAX (Data Analysis Expression)
DAX (Data Analysis Expression)
- Math & Stats Functions : Sum, Average, Max/Min, Divide, Count/Counta, Countrows, Distinctcount
- Interactor Functions: SUMX, AVERAGEX, MAXX/MINX, RANKX, COUNTX
- Logical Function: IF, IFERROR, AND, OR, NOT, SWITCH
- Text Function: Concatenate, Format, Left/Mid/Right, Upper/Lower, Proper, Len, Search/Find, Replace, Rept, Substitute, Trim
- Filter Function: Calculate, Filter, All, Allexcept, Related, Distinct, Values
- Date Function : Datediff, Yearfrace, Year/Month/Day, Hour/Minute/Second, Today/Now, Weekday/Weeknum
Working in the Report View to Visualize our Results
Working in the Report View to Visualize our Results
- Understanding the Interface of the Report View
- Creating our First Visualizations
- Editing Interactions and Adding Tooltips
- Adding Color Saturation
- Understanding Hierarchies and Adding Drill-Down
- Formatting charts and Sorting
- Essential Formatting setting : Color, Data Labels, Axis, Placement, Legends, Value
- Table View vs. Matrix View
- Conditional Formatting in Table View
- Basic Charts: Line, Bar Chart, Column Chart, Tree map, Pie, Doughnut, Area
- Tooltips – On hover Text
- Color Saturation in Column Chart
- Slicers: Vertical list Vs. Horizontal tiles
- Text Cards
- Adding Tree maps and Tables
- Applying different Filter Types
- Creating Multi-Row Cards
- Understanding Combined Visualizations and Waterfalls
Conditional columns and Data Segmentation
Conditional columns and Data Segmentation
- Conditional Columns: Writing multi-layered If Conditions
- Segmentation: Use “Group By” to calculate aggregated calculation based on clusters
- Segmentation: Use “Binning” to categorize values into equally sized groups
Advance Visualization
Advance Visualization
- KPI & Gauge Chart
- Forecast, Trent-line
- Map Visuals
- Custom Visuals – Downloadable Charts
- Use Drill down/up feature to specify chart behavior – granular view
- Show/Expand next level
- Filter level: Report level vs Page level vs Visual level
Power BI Service
Power BI Service
- Introducing Power BI Service
- Connecting to Data
- Gateway Refresh and Data Flow
- Understanding Gateways
- Gateway Types
- Reports & Dashboard
- Sharing & Collaboration Tool
- Power BI Mobile
- My Workspace Vs. App Workspace
- Creation App Workspace
- Report Reading tool in Power BI Service
- Pining tiles to Dashboard
- Pining Entire report to Dashboard
- Dashboard interface
- Manage Alerts
- Generate Quick insight
- Adding personal Bookmarks
- Web Vs. Mobile Layout
Just Full of details exposure.