Business Intelligence with Power BI Desktop

Master Power BI, Data analysis, Visualization and designing Dashboard

What you will learn

Understand the business intelligence workflow

Transform raw data into an interactive dashboards

Build professional-quality business intelligence reports from the ground up


– Power BI is becoming the most powerful self-service business intelligence platform, and an absolutely essential tool for data professionals and beginners alike

– A comprehensive, guide to learning Microsoft Power BI Desktop.

– You can connect to hundreds of data sources, build complex relational models using simple and intuitive tools,

– You can design stunning, interactive dashboards from scratch

– You’ll Lead Business Intelligence Analyst for business case, to design and deliver a professional business intelligence solution.

– Don’t worry, I’ll be with you to get dirty with this project step – by- step

– Whether you’re a casual Power BI user, aspiring analyst, or data science professional, this course will give you the tools you need to become an absolute Power BI expert, Guaranteed

– Students will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together

Course Structure :

– Section 1 : Introduction to Data analysis and power Bi Desktop

– Section 2 : Connection and Shaping Data

– Section 3: Table Relationships and Data Model

– Section 4: Analyzing Data with DAX

– Section 5: Data Visualization with Power BI Desktop

Who this course is for:

  • Data Analysts
  • Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
  • Anyone looking to pursue a career in data analysis or business intelligence






2. Connection and Shaping Data

Introduction and adjusting settings in Power Bi

2-2.Transform data in power bi

2-3. Dealing with texts – Voice Problem

2-4.Dealing with numbers

2-5.Working with Date & Time

2-6.Index column and conditional column

2-7.Grouping & Aggregating

2-8. Pivot & unpivot Demo 1

2-8. Pivot & unpivot Demo 2

2-9. Merging Queries

2-10. Append Queries

2-11.Connecting a folder

2-12. Data source sitting and refreshing in report

2-13. Data type and categories in PBi

2-14. Hierarchies in PBi

3. Table Relationships and Data Model

3-1.The issue and Data model

3-2. Normalization and understand Data table & Data lookup

3-3. Creating table relationship

3-4. Snowflake schemas

3-5. Editing relationship and Active vs. Inactive relationship

3-6. Connect multiple data table

3-7. Filter flow

3-8. Bi direction ( two-way) direction filter

3-9. Hiding fields from the report view

4. Analyzing Data with DAX

4-1. Intro to DAX and calculated column

4-2. Intro to measures

4-3. Adding measures, Implicit vs. Explicit measures

4-4. DAX Date & Time function 1

4-4. DAX Date & Time function 2

4-5.DAX. IF-OR-AND functions

4-6. DAX, Common text functions

4-7. DAX , Joining Data with related

4-8. DAX, Math functions

4-9. DAX. Count functions ( Count, COUNTA, Countrows, distinctcount)

4-10. important

4-11. DAX, Calculate function

4-12. DAX, Calculate ALL

4-13. DAX, Filter

4-14. DAX, Iterator functions

4-15. DAX, Time intelligence

Data Visualization with Power BI Desktop

5-2. Basics of Visualization Data in Power BI

5-3. Formatting options

5-4. Filter Options

5-5. Explore data with Matrix

5-6. Filter Data with slicers

5-7. Cards and KPI Visuals

5-8. Text Cards

5-9. Visualizing Data with Maps

5-10. Visualizing Data with Tree maps

5-11. Trendline and Area Chart

5-12. Trendline with forecasts

5-13. Goal pacing with gauges chart

5-14. Edit Report Interactions

5-15, Drill Through Filter

5-16. Report Bookmarks

5-17. What if analysis

5-18. Managing and Viewing Roles

5-19. More visuals, Mobile Layout and PBI Service need cut

Source link

Check Today's 30+ Free Courses on Telegram!

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock