Enter your keyword

Course

Power – BI And Dax – Master Class.

New Hot

About Instructor

What you'll learn

 

Transform, analyze& visualize data with Microsoft Power BI Desktop: hands-on demos, projects

Suggested Prerequisite

Students should have attended our Business Data Analysis and Basic and Intermediate Excel or have the knowledge area outlined.

Program Deliverables

  1. A training notepad with pen and a comprehensive study material
  2. Practice files and cases
  3. Lunch and Teabreak
  4. Post training support
  5. A training certificate from us
  6. You have to bring a laptop for the workshop

What you'll learn

In this course, you’ll be playing the role of Lead Analyst for a global manufacturing company. Your mission? Design and deliver a professional-quality, end-to-end business intelligence solution, armed only with a handful of raw csv files.We’ll be guiding you through the ins-and-outs of Power BI Desktop, sharing crystal clear explanations and helpful pro tips each step of the way.We’ll follow a steady, systematic progression through the B.I. workflow, and break down our project into four key objectives:

OUTLINE

OBJECTIVE #1: Connect & Transform the Raw Data
This will take you through Intro to the Query Editor.
This will take you through Types of Data Connectors.
This will take you through Basic Table Transformations.
This will take you through Text, Number & Date Tools.
This will take you through Index & Conditional Columns.
This will take you through Grouping, Aggregating, Pivoting & Unpivoting.
This will take you through Modifying, Merging & Appending Queries.
This will take you through Connecting to Folders.
This will take you through Defining Hierarchies & Categories.

OBJECTIVE #2: Build a Relational Data Model
This will take you through Intro to Database Normalization.
This will take you through Data (Fact) Tables vs. Lookup (Dimension) Tables.
This will take you through Creating Table Relationships.
This will take you through Star vs. Snowflake Schemas.
This will take you through Active vs. Inactive Relationships.
This will take you through Filter Context & Cardinality.
This will take you through Connecting Multiple Data Tables.
This will take you through Hiding Fields from Report View.
This will take you through Data Modeling best Practices.

OBJECTIVE #3: Add Calculated Fields with DAX
This will take you through Intro to Data Analysis Expressions (DAX).
This will take you through Calculated Columns vs. Measures.
This will take you through Row Context vs. Filter Context.
This will take you through DAX Syntax & Operators.
This will take you through Basic Date & Time Intelligence Formulas.
This will take you through Logical & Conditional Statements.
This will take you through Text, Math & Stats Functions.
This will take you through  CALCULATE, ALL & FILTER Functions
This will take you through DAX Iterators SUMX, AVERAGEX.
This will take you through DAX Best Practices.

OBJECTIVE #4: Design Interactive Reports
This will take you through Intro to the Power BI Report View.
This will take you through Adding Objects & Basic Charts.
This will take you through Formatting & Filtering Options.
This will take you through Slicers, Timelines, Cards & KPIs.
This will take you through Map Visuals Basic, Fill, ArcGIS.
This will take you through Treemaps, Lines, Areas & Gauges.
This will take you through Editing Report interactions &Drill through Filters.
This will take you through  Using Report Bookmarks & Parameters.
This will take you through Managing & Viewing Roles.
This will take you through Data Visualization Best Practices.

By the end of the project, you’ll have developed an entire BI tool from the ground up, and gained the knowledge and confidence to apply these same concepts to your own real-world analyses.

 

 

 

Reviews Statistic

0
0 out of 0
0 Ratings
5 Start 0
4 Start 0
3 Start 0
2 Start 0
1 Start 0

Reviews

There are no reviews yet.

Be the first to review “Power – BI And Dax – Master Class.”

Start On April 28, 2016
Duration 5 Days
Level Master
AlvaPro eSolution AlvaPro eSolution
Seat avaiable 15

Share our course