Business Intelligence & Data Analysis هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

Day 1: Data analysis tools and techniques
· Consolidating data from separate files and sheets
· Advanced data validation using lists, dates and custom validation
· Powerful array functions
· Cell management tools: left, right, mid, concatenate, value
· Naming, editing, and managing cells and ranges
· Subtotal, sumif, sumifs, sumproduct, count, countif, countifs
· Looking-up data, texts, and values using vlookup
· The incredible table-tools technique
· Slicing dates into day names, weeks, week numbers, month names, years and quarters
· Text-to-columns and dynamic trimming using trim and len
· Managing texts and numbers using replace, find, and substitute
· Text change functions
 
Day 2:  Mastering data reporting: the 19 must learn pivotables tools
· Creating pivot tables
· Number formatting techniques
· Designing report layout
· Sorting in ascending, descending and more sort options
· Filtering labels and values
· Expanding and collapsing reports
· Summarize data by sum, average, minimum, maximum, count
· Show values as % of total and % of Pivot table options
· Inserting formulas
· Data analysis Copying pivot tables
· Creating pivot charts
· Dynamic chart labeling
· Mastering the slicer
· Showing report filter pages
· Linking pivot tables and pivot graphs with PowerPoint
· Conditional formatting with pivot tables
· Designing reports using the getpivotdata
 
Day 3: Data modeling and integration
· Spinner
· Check box data modeling with if function
· Option button data modeling with if function
· List box data modeling with choose function
· Scenario manager
· Linking Excel with text files
· Linking Excel with databases (Access)
· Linking Excel with SQL
· Linking Excel with internet
· Linking Excel with Excel
 
Day 4: The look and feel: charting and visualization techniques
· Using the camera tool
· Working with formula-driven visualizations
· Using fancy fonts
· Leveraging symbols in formulas
· Working with sparklines
· Creating unconventional style charts
        Tips and tricks
· Controlling and protecting your reports, worksheets and workbooks
· Data entry form Custom list
· Text-to-speech Advanced conditional formatting
· Shortcuts for your daily work تحديث بتاريخ 17 November, 2022