Module 1: Introduction to Power BI and Business Intelligence
• Introduction to Business Intelligence
• Why Business Intelligence
• Characteristics of Business Intelligence
• Introduction to Data Analytics
• Types of Data Analytics
• Data Analytics Life cycle
• Data Visualization in Data Analytics
• Introduction to Data Visualization
• Overview of Self-Service BI
• Power BI Overview
Module 2: Getting started with Power BI
• Power BI Environment
• Components of Power BI
• Architecture of Power BI
• Power BI product portfolio
• Connecting to Data sources in Power BI
Module 3: Data loading and transformation in Power BI
• Data load in Power BI
• Introduction to Query Editor
• Working with columns
• Addressing errors
• Adding a calculated column
• Ordering Columns
Module 4: Power BI Data Model
• Overview of Data Modelling
• Why use data model?
• Introduction to Schema
• Star Schema
• Snowflake Schema
• Galaxy Schema
• Fact Constellation Schema
• Managing data relationship in Power BI
• Overview of Cardinality
• Cross filter Direction
Module 5: Data Analysis Expressions (DAX)
• Introduction to DAX
• Functions in DAX
• DAX Syntax
• Creating Measures
• Adding measures in Report
• Introduction to Calculated tables
• Creating Calculated tables
• DAX Operators
• DAX parameter naming
Module 6: Interactive Data Visualizations
• Types of visualizations in Power BI
• Clustered Column Chart
• Matrix Visual
• Pie Chart
• Gauge Chart
• Card Visual
• Scatter Chart
• Funnel Chart
• Visual Map
• Overview of Filters and Slicers
• Filter pane
• Adding Filters
• Creating visuals Using Filters
• Overview of Slicers
• Creating a slicer
• Overview of Bookmarks
• Adding Bookmarks
• Applying Bookmarks
Module 7: Publish and Share Using Power BI Services
• Introduction to Power BI Service
• Elements of Power BI service
• Building blocks of Power BI
• Dashboards in Power BI
• Reports in Power BI
• Workspaces, Capacities and Data sets
• Working with Workspaces in Power BI
• Publishing Reports on Power BI Service
• Creating Power BI Dashboard
Module 8: Power BI Dashboard and Custom Visuals
• Creating Dashboards from reports
• Working with Dashboard Tiles
• Customize the URL and Title
• Configuring a dashboard
• Sharing Dashboards in Power BI
• Enabling Natural Language Queries
• Filtering content in Dashboard
• Best practices in Dashboard
• Scheduling refresh for
• Overview of Custom Visuals
• Getting Custom visuals
• Developing Custom visuals in Power BI (module 4)
Module 9: Creating and Publishing Power BI Apps
• Overview of Power BI Mobile App
• Features of Power BI Mobile Apps
• Create reports for Mobile View
• Features of Mobile view layout
• Publishing an app in Power BI
• Accessing an app in Power BI
• Updating an App
Module 10: Power BI APIs, Power BI Embedded & SSAS
• Overview of Power BI API
• REST APIs
• Pushing data into datasets using Power BI APIs
• Overview of Power BI Embedded
• How to embed content
• Overview of SSAS
• Connecting SSAS Model
• Gateways
Module 11: Data Security and Administering Power BI
• Data security capabilities in Power BI
• Overview of Row level security (RLS)
• Roles and Rules
• Defining and validating roles
• Power BI admin portal overview
• Settings in Admin portal
Course project
Retail Store chain transformation
Business Intelligence (BI) tools are adopted by more and more companies in the current environment that requires companies
to operate as efficiently as possible. The case study investigates a BI adoption in a retail chain. Based on qualitative research methods, it analyses the Business
Intelligence life cycle; it evaluates factors impacting the adoption from the Diffusion of Innovations perspective.
The present study tried to help the upcoming retail store to solve the problem of transformation from traditional way of
doing business to the digital way. Automate the data collection where available and create integrated set of dashboards that
will free up time for the business analysts to get away from some report production time and spend more time on analysis that
will greatly benefit the business in the long-term.