MicroStrategy BI

MicroStrategy BI

1. Microstrategy BI Sudheer Reddy P
2. Before We Start  Sudheer Reddy P  Participants – What do you do? – Why are you taking this course?  Course details – Theory + practice 2 Microstrategy
3. Trainer BOI Name : Sudheer Reddy P Total IT Experience: 7 Years Relevant Experience: 5+ years in Microstrategy Skills: Microstrategy, Power Bi and Hadoop 3 Microstrategy
4. Before we begin – Schedule  Starts 09:30  Ends 16:30  Lunch – 60 mins  Break 4 – 10-15 mins AM – 10-15 mins PM Microstrategy
5. Course details Course title: QT Programming  Scope: – By the end of this training, participants will be able to:  Install and configure MicroStrategy  Use MicroStrategy to perform predictive analytics on large data sets  Access and analyze data from data warehouses, Excel files, etc  Create elaborate reports and dashboards – Trainer evaluation sheet  Sent to your email inboxes – Course certificates of completion  Sent to your email inboxes 5 Microstrategy
6. QT Programming Topic title • Introduction • Installing and Configuring MicroStrategy • Overview of MiroStrategy Features and Design • Understanding MicroStrategy Hierarchy and Grouping • Connecting to a Data Source • Designing Schema Objects • Creating Application Objects • Overview of the Report and Query Execution Workflow • Creating a Report • Manipulating Report Data • Creating a Dashboard • Troubleshooting • Summary and Conclusion 6 Microstrategy
7.  Introduction – What is Microstrategy? – Why Microstrategy? – Microstrategy benefits? – Overview of Microstrategy features  Installing and Configuring MicroStrategy – How to download and install the Microstrategy – How configure Microstrategy – How change Project Configuration Download link for Microstrategy Desktop: – https://www.microstrategy.com/us/get-started/desktop 7 Microstrategy
8.  Installing and Configuring MicroStrategy – Follow below steps to download and install the Microstrategy. Before installation check the system requirements. Operating system – Windows 7, 10 – 64-bit /Linux RAM – Minimum 8GB Adobe Reader 10/11 version Hard disk space – minimum 100GB 8 Microstrategy
9. Step1 :- Download the Microstrategy software from the site. 9 Microstrategy
10. Step 2:- After downloading extract the microstrategy .zip file Step 3:- In the above screen short there are two components desktop and developer tool. 10 Microstrategy
11. Step 4:- install desktop 11 Microstrategy
12. 12 Microstrategy
13. Step 5: Installation of developer tool. 13 Microstrategy
14. 14 Microstrategy
15. 15 Microstrategy
16. 16 Microstrategy
17. 17 Microstrategy
18. 18 Microstrategy
19. 19 Microstrategy
20. 20 Microstrategy
21. 21 Microstrategy
22. 22 Microstrategy
23. 23 Microstrategy
24. 24 Microstrategy
25. 25 Microstrategy
26. 26 Microstrategy
27. 27 Microstrategy
28. 28 Microstrategy
29. 29 Microstrategy
30. 30 Microstrategy
31. 31 Microstrategy
32. 32 Microstrategy
33. After installation Goto -> Start menu -> Developer -> click the developer it open like this. 33 Microstrategy
34.  MicroStrategy Hierarchy and Grouping – what is Hierarchy ? – How to use Hierarchy is Microstrategy? – What is Grouping – How it will use full in the Microstrategy? – Types of Groups 1. Custom Groups 2. Consolidations  Connecting to a Data Source – How to connect data sources – How to import are export the data from Microstrategy – How many types data extraction in Microstrategy 34 Microstrategy
35. 35 Microstrategy
36.  Types of Objects – Configuration Objects – Public Objects – Schema Objects – Report Objects – What is use of the objects? – How will we use in the Microstrategy?  Metric Types – Simple Metric – Compound Metric – Conditional Metric – Level Metric 36 Microstrategy
37.  Attribute Types – Simple – Derived  Report Types – Grid – Freeform SQL  OLAP Services(Online Analytical Processing) – Aliasing – Banding – Page-by – Sorting – Subtotals – Thresholds 37 Microstrategy
38.  Basic Reporting – Report Types – Drilldown – Creating Metrics  Advanced Reporting – Creating Derived Metrics – Creating Filters – Advanced Filters 1. Search Box 2. Radio Button 3. Drop down – Refreshing Reports – Intelligent Cubes 38 Microstrategy
39. 39 Microstrategy
40. 40 Microstrategy
41. 41 Microstrategy
42. 42 Microstrategy
43.  Report Types Grid Reports Graph Reports Combined Reports How to create Report? How Use the report in the Document? How to Troubleshoot the reports? 43 Microstrategy
44. 44 Microstrategy
45. 45 Microstrategy
46. 46 Microstrategy
47.  Dashboards What is dashboard? What is use of the dashboards? How to create the dashboards? 47 Microstrategy
48. 48 Microstrategy
49. 49 Microstrategy
50.  Microstrategy Architecture Generally MicroStrategy follows 3 kinds of architectures. - 2 - Tier Architecture - 3 - Tier Architecture - N - Tier Architecture  2-Tier Architecture (Direct Mode) In the two tier architecture the client connects directly to the metadata and data Warehouse. A 2-tier connection mode connects the project to the metadata via an Open Database Connectivity (ODBC) data source name (DSN). The following diagram shows the 2-tier architecture. 50 Microstrategy
51.  3-Tier Architecture (Server Mode) In the 3-tier architecture the client connects to the metadata and the data Warehouse through the Intelligence Server. Following diagram shows the 3-tier architecture. 51 Microstrategy
52.  Multi-Tier Architecture (Server Mode) In the Multi-tier architecture the client connects to the Intelligence Server (IS) through the Web server from the web browser. The IS in turn connects to the metadata and the data Warehouse. Following diagram shows the 3-tier architecture. 52 Microstrategy
53. MicroStrategy - Data Marts  What is data mart? Data mart is a smaller form of data warehouse, which serves some specific needs on data analysis.  What is the use of data marts?  How to create data marts? 53 Microstrategy
54. THANK YOU 54 Microstrategy
No comments...
none

Related Slides