How It Works
Course outcomes
1.Check for data inconsistencies
2.Use data profiling to create efficient queries
3.Write efficient DAX code
4.Add trendlines to charts
5.Add Objects and Bookmarks to reports
Course objectives
1.Provide an understanding of Data Profiling in Power Query.
2.Have students learn how to create a Fuzzy Match
3.Give an understanding the difference between Duplicate and Reference Queries
4.Have students know the differences between relationship types
5.Explore advanced DAX functions
6.Create a Key Influencer visual
About Online Learning
How the Course Works
It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom. You will have a password and use your email address and password to gain access. Once inside the online classroom, here's what you can expect.
What You Will Do
For each Unit, you will:
- Access the online readings
- Listen to the audio presentation for the Unit and view the slides
- Take a self-quiz to see how much you have learned
- Engage in written online discussion with your instructor and other participants
For best learning, you should make one or more comments at 2-3 different times each day.
The content (readings, audio lectures, slides) and self-quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience.
Participate When You Want
You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week. There are no live real-time requirements or meetings. You decide when you participate.
For the best learning, participants should log into the course on 2-3 different days of the week.
Discussion
The Discussion for each Unit lasts one week. All comments are made in writing and can be made at any time of the day or night.
Your instructor will log into the Discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants.
We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.