Business intelligence Developer

Course Description

Have you ever asked yourself how data can help business make better decisions? Business intelligence can help companies make better decisions by showing present and historical data within their business context. Analysts leverage BI to provide performance and competitor benchmarks to make the organization run smoother and more efficiently. Analysts can also more easily spot market trends to increase sales or revenue. Used effectively, the right data can help with anything from compliance to hiring efforts.

You want to analyze data from single or multiple sources? You want to create your individual datasets based on these sources and transform your results into beautiful and easy-to-make visualizations? You also want to share your results with colleagues or the whole organization? Finally, you want to be able to access your data from multiple devices whilst keeping enterprise-grade performance settings?

Then the Power BI tools are the tools to choose for you!

To make you ready for enterprise-grade modelling and keep the performance up and running, we will spice-up PowerBI with Microsoft SQL Server data analysis techniques.

Course Objectives

  • Use SQL to query a database and perform data analysis
  • Be comfortable putting SQL and SQL Server on your resume
  • Replicate real-world situations and query reports
  • Prepare SQL reports for performance boost of PowerBI reports.
  • Get to know the different tools of the Power BI universe and learn how to use them
  • Understand Power BI Desktop and its components
  • 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
  • How to work in the different views of the Data Model
  • How to create calculated columns and measures
  • How to build relationships between different tables
  • How to apply advanced DAX to prepare stunning visualization and reports
  • How to create a report with different interactive visualization types
  • Learn how to use Power BI Service to create dashboards and to share and publish your results
  • How to access your results from multiple devices using Power BI Mobile
  • Be comfortable putting Microsoft PowerBI on your resume
  • Prepare for Microsoft Data Analyst Certification
  • And more!

Students are required to have stable internet connection for online course following. Students are required to have a Windows 10 laptop with 1.8GhZ processor and 4GB RAM. Exceptionally, spare laptops and/or VMs will be provided for students with no access to laptops with required technical capacity.

Course heavily rely on using PowerBI Desktop and SQL Server Management Studio. Although all required skills will be demonstrated throughout the course, students are encouraged to get familiar with abovementioned tools to follow the course more efficiently.

Course Schedule

TopicItem
IntroBI principles, history – what is modern BI
BI Tools and techniques overview
SQLRole of SQL in BI Reporting
Basic SQL commands – SELECT, WHERE, GROUP BY, ORDER BY
Advanced features for report builders – Stored procedures and Common Table Expressions
Views as a main PowerBI sources
Data PreparationWorking in Query Editor
Overview of different data sources
Data ModellingUnderstanding relationships
STAR and SnowFlake schema and their importance
Data analysis – advanced DAXDAX Engine, tips and best practices
Scalar Functions
ADVANCED CALCULATE
Table, filter and relationship functions
Iterator functions
Advanced Time intelligence
Performance tuning
Data VisualizationCreating visuals with PowerBI desktop
Reports and dashboards in PowerBI Service
Collaborating on and deploying reportsUnderstanding datasets and workspaces
Row-level security and role-based access to reports

Assignments

Written assignments
 Assignment 1: Sales Data Analysis in SQL Server
 Assignment 2: Cleansing of “old” and ill-formatted data
 Assignment 3: Company Budget and P&L in Power BI
 Assignment 4: Collaborative project

Course completion certificate

  • The course certificate is based on achievement of course objectives.
  • All assignments must be completed to satisfactorily pass the course. Assignments are graded and minimum of 50 points is required to get the certificate.
  • A final assessment shall be made with minimum of 70% or greater score to pass the course and get your certificate.
en_USEnglish