UP & RUNNING WITH MICROSOFT POWER BI DESKTOP
INTRODUCING POWER BI
-
5MEET POWER BI
MEET POWER BI
-
6MEET POWER BI
MEET POWER BI
-
7WHY POWER BI?
WHY POWER BI?
-
8EXCEL VS. POWER BI
EXCEL VS. POWER BI
-
9INSTALLING POWER BI DESKTOP
INSTALLING POWER BI DESKTOP
-
10POWER BI SETTINGS
POWER BI SETTINGS
-
11POWER BI WORKFLOW
POWER BI WORKFLOW
-
12POWER BI WORKFLOW
POWER BI WORKFLOW
-
13POWER BI WORKFLOW
POWER BI WORKFLOW
-
14POWER BI WORKFLOW
POWER BI WORKFLOW
-
15POWER BI WORKFLOW
POWER BI WORKFLOW
-
16HELPFUL RESOURCES
HELPFUL RESOURCES
-
17MONTHLY UPDATES
MONTHLY UPDATES
CONNECTING & SHAPING DATA
-
18CONNECTING & SHAPING DATA
CONNECTING & SHAPING DATA
-
19FRONT-END VS. BACK-END
FRONT-END VS. BACK-END
-
20TYPES OF DATA CONNECTORS
TYPES OF DATA CONNECTORS
-
21POWER QUERY EDITOR
POWER QUERY EDITOR
-
22QUERY EDITING TOOLS
QUERY EDITING TOOLSS
-
23BASIC TABLE TRANSFORMATIONS
BASIC TABLE TRANSFORMATIONS
-
24ASSIGNMENT: TABLE TRANSFORMATIONS
-
25SOLUTION: TABLE TRANSFORMATIONS
SOLUTION: TABLE TRANSFORMATIONS
-
26PRO TIP: STORAGE & CONNECTION MODES
PRO TIP: STORAGE & CONNECTION MODES
-
27CONNECTING TO A DATABASE
CONNECTING TO A DATABASE
-
28EXTRACTING DATA FROM THE WEB
EXTRACTING DATA FROM THE WEB
-
29DATA PROFILING: COLUMN QUALITY
DATA PROFILING: COLUMN QUALITY
-
30DATA PROFILING: COLUMN DISTRIBUTION
DATA PROFILING: COLUMN DISTRIBUTION
-
31DATA PROFILING: COLUMN PROFILE
DATA PROFILING: COLUMN PROFILE
-
32TEXT TOOLS
TEXT TOOLS
-
33ASSIGNMENT: TEXT TOOLS
-
34SOLUTION: TEXT TOOLS
SOLUTION: TEXT TOOLS
-
35NUMERICAL TOOLS
NUMERICAL TOOLS
-
36ASSIGNMENT: NUMERICAL TOOLS
-
37SOLUTION: NUMERICAL TOOLS
SOLUTION: NUMERICAL TOOLS
-
38DATE & TIME TOOLS
DATE & TIME TOOLS
-
39DATE & TIME TOOLS
-
40CREATING A CALENDAR TABLE
-
41CHANGE TYPE WITH LOCALE
-
42CHANGE TYPE WITH LOCALE
-
43PRO TIP: ROLLING CALENDARS
-
44PRO TIP: ROLLING CALENDARS
-
45ASSIGNMENT: CALENDAR TABLES
-
46SOLUTION: CALENDAR TABLES
-
47INDEX COLUMNS
-
48CONDITIONAL COLUMNS
-
49CALCULATED COLUMN BEST PRACTICES
-
50GROUPING & AGGREGATING
-
51GROUPING & AGGREGATING
-
52PIVOTING & UNPIVOTING
-
53MERGING QUERIES
-
54APPENDING QUERIES
-
55PRO TIP: APPENDING FILES FROM A FOLDER
-
56DATA SOURCE SETTINGS
-
57PRO TIP: DATA SOURCE PARAMETERS
-
58REFRESHING QUERIES
-
59PRO TIP: IMPORTING EXCEL MODELS
-
60POWER QUERY BEST PRACTICES
CREATING A DATA MODEL
-
61CREATING A DATA MODEL
-
62WHAT IS A DATA MODEL?
-
63WHAT IS A DATA MODEL?
-
64DATABASE NORMALIZATION
-
65FACT & DIMENSION TABLES
-
66PRIMARY & FOREIGN KEYS
-
67RELATIONSHIPS VS. MERGED TABLES
-
68THE MODEL VIEW
-
69CREATING TABLE RELATIONSHIPS
-
70MANAGING & EDITING RELATIONSHIPS
-
71STAR & SNOWFLAKE SCHEMAS
-
72ASSIGNMENT: TABLE RELATIONSHIPS
-
73SOLUTION: TABLE RELATIONSHIPS
-
74PRO TIP: ACTIVE & INACTIVE RELATIONSHIPS
-
75PRO TIP: ACTIVE & INACTIVE RELATIONSHIPS
-
76RELATIONSHIP CARDINALITY
-
77EXAMPLE: ONE-TO-ONE CARDINALITY
-
78EXAMPLE: MANY-TO-MANY CARDINALITY
-
79CONNECTING MULTIPLE FACT TABLES
-
80FILTER CONTEXT & FLOW
-
81EXAMPLE: FILTER FLOW
-
82BI-DIRECTIONAL FILTERS
-
83EXAMPLE: BI-DIRECTIONAL FILTERS
-
84AMBIGUITY
-
85HIDING FIELDS
-
86ASSIGNMENT: FILTER FLOW
-
87SOLUTION: FILTER FLOW
-
88PRO TIP: MODEL LAYOUTS
-
89DATA FORMATS & CATEGORIES
-
90HIERARCHIES
-
91ASSIGNMENT: HIERARCHIES
-
92SOLUTION: HIERARCHIES
-
93DATA MODEL BEST PRACTICES
CALCULATED FIELDS WITH DAX
-
94CALCULATED FIELDS WITH DAX
-
95MEET DAX
-
96M VS. DAX
-
97CALCULATED COLUMNS
-
98EXAMPLE: CALCULATED COLUMNS
-
99DAX MEASURES
-
100IMPLICIT VS. EXPLICIT MEASURES
-
101QUICK MEASURES
-
102RECAP: CALCULATED COLUMNS VS. MEASURES
-
103PRO TIP: MEASURE TABLES
-
104FILTER CONTEXT
-
105EXAMPLE: FILTER CONTEXT
-
106STEP-BY-STEP MEASURE CALCULATION
-
107DAX SYNTAX
-
108DAX OPERATORS
-
109COMMON FUNCTION CATEGORIES
-
110BASIC MATH & STATS FUNCTIONS
-
111COUNTING FUNCTIONS
-
112ASSIGNMENT: MATH & STATS
-
113SOLUTION: MATH & STATS
-
114BASIC LOGICAL FUNCTIONS
-
115SWITCH
-
116ASSIGNMENT: LOGICAL FUNCTIONS
-
117SOLUTION: TEXT
-
118BASIC DATE & TIME FUNCTIONS
-
119ASSIGNMENT: DATE & TIME
-
120SOLUTION: DATE & TIME
-
121RELATED
-
122CALCULATE
-
123EXAMPLE: CALCULATE
-
124EXAMPLE: CALCULATE
-
125DAX MEASURE TOTALS
-
126ASSIGNMENT: CALCULATE
-
127SOLUTION: CALCULATE
-
128SOLUTION: CALCULATE
-
129ALL
-
130ASSIGNMENT: CALCULATE & ALL
-
131SOLUTION: CALCULATE & ALL
-
132FILTER
-
133ITERATOR FUNCTIONS
-
134ASSIGNMENT: ITERATORS
-
135SOLUTION: ITERATORS
-
136TIME INTELLIGENCE
-
137ASSIGNMENT: TIME INTELLIGENCE
-
138SOLUTION: TIME INTELLIGENCE
-
139DAX BEST PRACTICES
VISUALIZING DATA
-
140VISUALIZING DATA
-
141THREE KEY QUESTIONS
-
142THREE KEY QUESTIONS
-
143THREE KEY QUESTIONS
-
144THREE KEY QUESTIONS
-
145ANALYTICS DASHBOARDS
-
146DASHBOARD DESIGN FRAMEWORK
-
147THE REPORT VIEW
-
148ASSIGNMENT: CARDS
-
149SOLUTION: CARDS
-
150BUILDING & FORMATTING CHARTS
-
151BUILDING & FORMATTING CHARTS
-
152ASSIGNMENT: LINE CHARTS
-
153SOLUTION: LINE CHARTS
-
154FILTERING OPTIONS
-
155ASSIGNMENT: DONUT CHARTS
-
156SOLUTION: DONUT CHARTS
-
157CONDITIONAL FORMATTING
-
158ASSIGNMENT: TABLES
-
159SOLUTION: TABLES
-
160ASSIGNMENT: TOP N TEXT CARDS
-
161SOLUTION: TOP N TEXT CARDS
-
162MAP VISUALS
-
163SLICERS
-
164ASSIGNMENT: SLICERS
-
165SOLUTION: SLICERS
-
166DRILL UP & DRILL DOWN
-
167ASSIGNMENT: DRILL DOWN
-
168SOLUTION: DRILL DOWN
-
169DRILL THROUGH FILTERS
-
170REPORT INTERACTIONS
-
171ASSIGNMENT: REPORT INTERACTIONS
-
172SOLUTION: REPORT INTERACTIONS
-
173BOOKMARKS
-
174ASSIGNMENT: BOOKMARKS
-
175SOLUTION: BOOKMARKS
-
176PARAMETERS
-
177EXAMPLE: NUMERIC RANGE PARAMETER
-
178EXAMPLE: FIELDS PARAMETER
-
179ASSIGNMENT: FIELDS PARAMETERS
-
180SOLUTION: FIELDS PARAMETERS
-
181PRO TIP: CUSTOM TOOLTIPS
-
182IMPORTING CUSTOM VISUALS
-
183MANAGING & VIEWING ROLES
-
184MOBILE LAYOUT
-
185DATA VISUALIZATION BEST PRACTICES
ARTIFICIAL INTELLIGENCE
Be the first to add a review.
Please, login to leave a review