Data Analytics with Microsoft Power BI

Welcome to Data Analytics with Microsoft Power BI – A Project-based Approach. From Beginner to Advanced Level Course.

Our Data Analytics with Microsoft Power BI course is truly unique, detailed, and an absolute necessity for those seeking to become professional data analyst, Business Intelligence professional, working with the Microsoft Power BI platform.

In this course, you will learn data analytics by working through the task of a data analyst in a project-based scenario; you’ll be guided through the ins-and-outs of Power BI Desktop, with crystal clear explanations and insightful tips each step of the way.

Here are some more details of what you get with our Data Analytics with Microsoft Power BI course:

TASK #1: Data Preparation – Connect & Transform the Raw Data

• Intro to the Power BI Query Editor
• Types of Power BI Data Connectors
• Basic Table Transformations
• Text, Number & Date Tools
• Index & Conditional Columns
• Grouping & Aggregating Data
• Pivoting, Unpivoting & Transposing Table
• Modifying, Merging & Appending Queries
• Connecting to Folders
• Defining Hierarchies & Categories

TASK #2: Data Modeling – Build a Relational Data Model

• Intro to Data model
• Fact Tables vs. Dimension Tables
• Creating Power BI Table Relationships
• “Star” vs. “Snowflake” Schemas
• Active vs. Inactive Relationships
• Relationship Cardinality
• Connecting Multiple Fact Tables
• Filtering & Cross-Filtering
• Hiding Fields from the Power BI Report View

TASK #3: Data Analysis with DAX

• Intro to Data Analysis Expressions (DAX)
• Calculated Columns vs. Measures
• Row Context vs. Filter Context in Power BI
• DAX Syntax & Operators
• Common Power BI Functions
• Basic Date & Time Formulas
• Logical & Conditional Statements
• Text, Math & Stats Functions
• Joining Data with RELATED
• CALCULATE, ALL & FILTER Functions
• DAX Iterators (SUMX, AVERAGEX)
• Time Intelligence Formulas
• Handling Date Format Error

TASK #4: Data Visualization – Design Interactive Power BI Reports

• Intro to the Power BI Report View
• Adding Basic Charts to Power BI Reports
• Formatting & Filtering Options
• Matrix Visuals
• Slicers & Timelines
• Cards & KPIs
• Power BI Map Visuals (Basic, Fill map)
• Treemaps, Lines, Areas & Gauges
• Editing Report interactions
• Adding Drillthrough Filters
• Linking to Report Bookmarks
• Using “What-If” Parameters
• Managing & Viewing Roles
• Publishing to Power BI Service
• Power BI Artificial Intelligence Visuals 

This sounds great, right?

Our courses are unique because our team works hard to:

• Research and make relevant contents available
• Work with real-life examples
• Provide easy to understand and clear explanations
• Provide external resources to reinforce learning
• Prepare assignments, lecture summaries, quizzes, and other materials that will enhance your course taking experience
• Assist with job interview preparation and career guide
• Provide support and mentorship whenever required