Data Analytics with SAP Lumira | Ellie Babadi Koerber | Skillshare

Data Analytics with SAP Lumira

Ellie Babadi Koerber, Sr BI Consultant

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
18 Lessons (1h 17m)
    • 1. Welcome!

      0:52
    • 2. Introduction

      1:32
    • 3. Acquire Data

      3:24
    • 4. Prepare Data Measures and Dimensions

      8:59
    • 5. Prepare Data Hierarchies

      2:14
    • 6. Visualize - Introduction

      4:35
    • 7. Visualize - Column Chart

      5:08
    • 8. Visualize - Cross tab table

      3:31
    • 9. Visualize - Column chart 2-Y-Axes

      7:27
    • 10. Visualize - Geo Pie chart

      2:45
    • 11. Visualize - Line chart

      3:46
    • 12. Visualize - Pie chart

      2:27
    • 13. Visualize - Scatter plot

      1:29
    • 14. Visualize - Predictive Analysis

      3:45
    • 15. Compose your story

      14:39
    • 16. Sharing your story

      3:58
    • 17. Final notes

      4:03
    • 18. Lumira Cloud

      2:32

About This Class

Struggling with creating a dashboard for your business analysis purposes? Take this new tutorial course based on the latest easy-to-use technology from SAP and learn in a simple way how to create a dashboard without help from IT.

Live step-by-step tutorials take you through the main functionalities of the Lumira tool. The course teaches you not only how to use the tool but also why you use the tool.

This course is for anyone interested in Business Intelligence at difference levels and with different platforms (SAP Hana, Microsoft SQL, Oracle, Hadoop etc).

This course also can help consultants and developers who would like to learn about the full functionality of this new tool and bring any source of data and create visualizations to find hidden patterns.

Learn from a Business Intelligence IT professional with 12 years of experience in different industries such as retail, oil and gas, and manufacturing in both the public sector and private sector across North America.

Benefits of this course:

  • Transform data into visual information that your organization can use to make better business intelligence decisions and increase performance.
  • Identify negative trends in key performance indicators.
  • Fix negative trends by localizing them, analyzing them, and correcting them.
  • Improve the efficiency of forecasting.
  • Measure a company‚Äôs performance parameters.
  • See pure data more clearly with visualization techniques that find hidden patterns.
  • Eliminate IT for any single reporting requirement.

Transcripts

1. Welcome!: I'll come to assemble a mirror the easy way to create your own dashboard and analytics. I've been a senior FBI consultant for so many years in so many industries. I've seen many B I challenges, and I know what benefit be I can bring to you on. I'm in touch on up to the did the best practices. In this video, you will learn how to create different dashboards in analytics. You can bring any source of doctors from anywhere, create your own visualization and forecasts your dot bring of your story on cloud and share it with others. It's easy technology to use wherever you go on your mobile and tablet on whatever you do. 2. Introduction: Welcome to Data Analytics with us AP Low Mira. I've been a senior B I consultant for so many years and currently the leader supervisor for B I. Team. I've been in so many by projects before, and I'm so up to date with the best practices on dashboard best practices as well. In this course, you will learn how to bring your data from any source. Do action on your data in richer data on view it. Visualize it on after you visualize and you create your own graphs and charts. You can create your story board on, then share it with anyone you like. Who are the audiences for discourse? It could be any audiences. It could be just business users at operational level. Or it could be at management level or above. Or even it could be I t developers who would like to know the full functionality off this tool and create the visualization for team. Whether the benefits of taking these scores basically you would be able to turn your data into information, you can find hidden patterns in your data on makes sense off your data. You can't forecast your natto. You can do all this with no help from I t. Because Ramiro is supposed to be a business user, too 3. Acquire Data: Now, let's see Holum era works. So if you open the luminaries s a kilometer application, You see, there are a couple of options here. Um, if you're working for a company that have Lameda on S a P B I server, you can go here on typing your credential and user I D and password and server name and connect directly to the server. If you go to the file, we want to add new file here. As you see, there are many options here. One off. The option is if you want to upload Microsoft Excel or if you want oh, upload on, bring in text data. You can also copy from clipboard. There's also connection for estate behind other two options. Here, the 1st 1 connects to s a piano in real time, which means that you can get access on fish that are from real time from handle the 2nd 1 you can access and get that off off line for a miss A piano. So you access the view as a data set. You can also get the information from ASAP VW Business warehouse. So if you have, um, if your company has s a p p w. And you want to connect backstory or bring that off from business warehouse, You choose this option on. Then after you come here, you have to put the server and your credential and you can connect to S A P P W or back score. Um, bring your battle. You can also bring your data from universe panel. So, um, that's another option on plus Microsoft SQL Server. If you have your data there, you can also bring the data from their. But for any off this, you have to go to the setting and put the credential on and the server and whatever is required to get your latter for this video we're going to bring in Microsoft Excel. So we click our next, find the file which is called Rental shop In here. As you see, we have there are some sitting that you have option to choose here. You can choose ah dxl shit on if you have. If you're Excel Sheet has too many tops, you can also choose upend all shits. Also, here you have the option. If your table this cross stop, you can also bring the cross table as well There is also advanced option here if it show you how much. If you want tohave arrange selection for your data. You can choose it and make your custom range. Or here if you want to start your doctor like from second row instead of first room. You can also do that. See, this is the doctor in the second Don't know vehicle back to the first row. There's also other options. If you want to show hidden columns or hidden role or if you aren't, check any off. This box is basically you do not bring that to the Woomera. You have the option to include columns or not. So then you Klay create. So now you acquired your data and you brought it to s a pill, Amir. 4. Prepare Data Measures and Dimensions: after you acquire your data or no, you're in prepare room. So your data set is here. Now, if you look at this, there are left in left panel. You see all the measures here that the mirror categorize it based on your data set on all the dimension that our data related to those measures are also located here, on here, on the top, right side. You're sitting a fresh Parton any time you make any changes to your excel or any data source, If you click on this, refresh Parton automatically. That that gets reflected inside the La Mira. And here you have to option for marriage and upend. If you want to merge another data source on bring it on. Connect the key in each table. You use this on our penned Aziz. Usual. If you want to upend the data to the existing table, let's try marriage. If you want, emerge another excel to this existing one. As you see, it gives us two option here. This is my main file on. This is the second fun. I have to find the key to merge. These two tables for me is titled, So I chose title here on. I chose title here, and it shows me that the matching columns are 100% compatible. I click merge and not this merger's created. If I go back to the Excel that I added, I said that I had tighter column here on a studio, and if I go back to Amira, I would say that the studio has been added here. So based on the title that emerged, the studio got added to this. Except the next second is here. You can create new calculated dimension or new calculated measure. Never go back to this later on here. You can select the columns to show any by checking or on checking you. So, like, what column you want to display in your data set on? Here is the facet feel facet view is another nice view off your data that gives you more information about your data. Like, for instance, in the city here, you don't only see city, but you also see how many occurrences off city of this city existing datasets. How many number off records which shows you 240 the same for all other columns. But let's go back to the great view because we want to play on applied data action toward data. Any dimension here, if you click on it, automatically highlights in the table. So here deserve all the dimension that's Lameda created based on the data sets you bring to LA Mira. So like if you click on the reserve column here, it shows on highlighted what we can do here. There are these data action that you can apply to the dimension. These are like duplicate rename splits remove convert case, replace, feel or convert to number, plus some more, which will go over some off that so here, like in this column. If you want to, for instance, replace mobile vit offside. You can apply that. And now you see that's in the column reserved. You said all the mobile was replaced by off site. You can also click on that on that dimension, and there is I can hear, which gives you all the functionality cannot like that dimension. You can filter Benny based on any specific item you want. Like if you want a filter on Fox on also their operators here that you can choose a range or not include or not equal to or all this condition that you cannot lie, um, and then filter on this and then you see that the studio has bean filter on Lee based on that filter. If you look at this studio here now, you see that on your only. See Fox on by checking. By removing this, you can totally remove the filter from the list. Other options are also convert to date or time. Create a major created geographic hierarchy. Custom higher key on. Also, you can rename and even remove or duplicate the column or murdered on also create calculated dimension. So, for instance, if you want to go to the idea column, and we want to create calculated dimension so here of envy Sorry, not create calculating machine. If you want Teoh, create major. So then we create measure basically automatically that I d will be added here, and it shows us count all. You can also change the aggregation based on what you want. You can have it as distinct or have it us out value. Add this year one off. The reason that you can use it is if you want to create a formula that was supposed to use that dimension? No, you have it as number here, and you can apply this formula. So if you want to, for instance, create new calculated measure. You want tohave to calculate revenue? Pair each box idea. So you have the idea. No. Here and you can just click on it and your name it priven you by box I d and click OK, and then you'll see that revenue by box I d have Bean added here, so it shows you the total of revenue based on each box by deep. Another thing you can do is, um, you can also if you for any. As I said, for any major, you can click on this icon. Here. You can change the aggregation based on max, mean or average or some ah, the functionality, and you can also rename or remove here. Another thing you can do is find the revenue column measures, usually always at the end off the table. So if you so left this by this, I can hear you have more accessibility to. More functionally did apply to your measure, including filter. You can apply filter on, select the range for that or create a measure out off this on all these things that is available here. Another think you can do that? The dimension is to, um, group them by selection or by range. So, for instance, if you want, if you want to look for instructor rating that we have here when you collect on rating, the column gets highlighted, so and then you come here and you want to group them by selection. What it does is it gives you the opportunity to from one dimension create another dimension that you categorize it based on your own criteria. So here, you know that the T stands for teenagers and, um, E is for everyone. We want to make sure that these two are the only movies that kids are allowing allowed to watch so we can call them. Call this new group. Call it kids, Andi For anything else, we call it the considerate. As adults on the Dimension name could be writing group or anything, you can change it based on whatever you want. So when we create okay, we said that rating group the new dimension has been added here on in here. If you look at it, it it has adults and kids based on the category V summarized that. So another thing you can see also here, you can also see here that based on this category, creative way are we have about 11,250 movies that are suitable for adults on only 2071 that are suitable for kids. 5. Prepare Data Hierarchies: okay. In this example, we want to show you how we can create geographical hierarchy or time higher. Keep if you go back here and look at here as you see, it's Lumina already tells you there are four dimensions identified as geographic or time higher kids. So if we go back to the city here and click on this icon, we can create a geographic hierarchy by names we can choose for region. We can choose the state, but these are all the higher the level that you know is going to create for you. So confirmed on these are the name off all the cities that are available Click done and here we will see that all the hierarchy has been created wall for country 14 region, 14 sub region. I want for this city the same. We can also do for the data time. So if we go to date here, click on the icon on. We create created date or time hierarchy, so the date can be divided into year quarter month on day. So if you click on year, you see disorder occurs all for 2013 on then for quarter one month on the day. So your revenue or all these measures that you see here can be divided up for categorized by thes time dimensions. You can also go back to the to the higher key. And if you if you don't want Teoh, but you don't want to include all of them, you can like a remove day and click OK on, then you have all the year, quarter and much So that was the brief description off to create Harkey. 6. Visualize - Introduction: Okay. The next step we're going to work on is visualized room. Visualized room is the room that you create all your graphs on. You can apply any role you want to your graphs. So here, as you see, there are different charts type here that you can use for your visualization on. There's also bald I can't hear If you click on this Bob icon Humira can give you the a visualization that they think they can create for you. Mental count by retailer Rent account by title, Right on count by rating. So these are the ones that such a step by Lumina in orderto active it is in case you didn't get that options. When you click on March, you can goto file on. You can go to Preference says on then to doctor said. And as you see it gives you the option. Would you like to display related visualization on a low Hello? Influence analysis. Okay, so these are like the chart that Nomura creates for you if you want to find rental account by retailer so you see that these are different retail or 7 11 blah, blah and then all these are the rental capped. Or if you want to find out the warrant account by title. These are all the titles that's available our rental count. By rating another option that's available here he is. If you click on any off these measures like rental account, it gives you the option off. What's influential rental account. What it means is Low Mirror can give you all the dimension that would be impacted by this major on gives you the different visualization as well. So if you click run analysis as you see, it gives you the option like you can have topping flew in shells off rental account. You can't have rent account by studio split, which is too much here. But is that the option? If you click on sure all you can also choose like rental. Can't buy tie as you see, let rental count by type. It gives you all the rental count based on different DVD, Blueberry City or whatever you had in your database on. If you click car rental account by title, it gives you based on the title I rental count by writing, So if you like any off thes visualization, you can't save it. and it creates this slight for you. This is what it's showing you here. So here is there to account for adults or matures. Are everyone all the ratings this year on? You can also have like you can click on this adds another graphs for you. You can't for this one you can choose your toe account by title then very brings you by title You on this one, you can create the filter on you can say OK, I want to find out their inter can for days for this city only. So you filter it or you can say I want to rent a can't for this based on the type If you find the time click up types here are you just wanna find other into account for the Blue Ray one, Not everything. Okay, so these are the options that's Lamido provides you based on the dimension that's been influenced by that measure. Red to account 7. Visualize - Column Chart: Now let's get back to the charts on how we can create chart from here. So as you see, these are the option for charts we have. If we click on column chart here, you have the option here to create column charts these around options. These are all the icons that you see at the top that you can use that. Apply to your chart like this bonds if you want to create new, refreshed line. If you want to create Drescher for your graft, put any value that for any value above or below that you want to create. Warning on this one is if you want to export after you do your graph, you want to export your file as CSP file or X S X. You have the option here to do that as well. The other one here is calculation. If you want to apply any calculation moving, average percentage difference from you can apply these from this arc. I can as well after you do your graph. If you want a feat that into the frame you see is not feeling well, you can click on that and sit options, and here is when you want to clear your chart, you want to clean it and erase everything. On here is the setting that if you want to show the data labels or great line or all those things for show, the title legend on Dhere is maximum. Your screen on here is refreshed. Anytime your data source the value in that those sorts changes. You can click out this refresh on your graph automatically. Refresh reflector. Most after the doctor I This is on the bottle. So let's create a simple graph now. So let's bring a gross margin on target to why access? So his gross margin on target. Remember the Savoy access You can only bring the measures into this on. Dimensions are here on If we bring the title to the X axis. So we find the title here. Okay, on you see is too many. You include the to measure. That's why religions here shows you the target. One is with this like blue and the green gross margin is great. So, um, this is the top 10 rankings. So if you clicked on that, you can say, OK, I just want to see the top 10 girls. Margie or target for this is all it means. Include me include four balls for all this titles. If you click OK, it only shows you the top 10 right? Or you can change it and said OK, give me the time. The top five from this. Okay, so, as you see, you have the top five. Based on gross margin on target, the top five is Columbiana on. This shows you, Uh, the green one is gross margins, which shows your 4 39,059 on your target is Terry 2000. The other thing you can do here if you click on you can apply any calculation here if you want. Plus, you can also or the setting. If you collect on, show that a label, it shows you the number right at the top off each column. So you know how much is that exactly? The other thing you can also to is if you want to uh if you want again, you can apply feature of this one. You can also show that Go to the type. I see. Okay. I just want to see the Pierce tree ones. So it shows you only the tiles that are for PS Street. Okay, then you can save that. So your trip third graf, nor is safe. 8. Visualize - Cross tab table: in this section. Let's try to create some cross stop tables. So if you choose the cross top table here on, uh, it gives you measures Colin sandals for measures. You choose revenue again to do some calculation on that. So a revenue here and measure automatically goes to the column here, Um, and for the rose we collect generates So here. So we said that our cross table has been created based on the revenue based on the type off , the movie or a game or whatever. We have the categories based on general. We can create conditional formatting here, which used this new role. So we want to see if any revenue is less than $80,000. For instance, it's highlighted to read for us, and we call it meaning minimum. I remember you. Okay, so as you see in the table now we see that any value that's less than 80,000 has been highlighted. Ah, let's also at the rating to the column as well to the rosary. So if you include rating, it categorize more expense, and we see that for like, action, we have values inside these ratings that the value is less than $80,000. And we can also apply some other logic to that. Like if we're going to find, um, any percentage, for instance, which is the percentage off this, um, by generate. So we want to see the percentage of its rating belong to generate what this percentage off the based of living you click. OK, so it adds another column called Percentage On Here. It shows you that 6% off this revenue, it's belongs to an R, 91% belongs to PG, and 2% belongs to rating. If you want a nobody's the rating groups. I think we already included that. We can also add a rating groups, so we know that which category these are belongs to like we know that t belongs only to kids. So we know that for games, 26 percents belong off revenue coming from kids on 36% from the everyone which kids are included in that as well. So these are the things that you can do it across that they will also you can click, highlight any column and said sized properties. You can hear I just the row and column the size and the wheat and I think you want in terms of the that high to change. Or you can also collect at the table the same thing. You text you to the setting for the size. 9. Visualize - Column chart 2-Y-Axes: in this session, We're going to show you how you can create to buy access column chart all the different things you can apply to that. So here I'm bringing to measures to buy access. One is revenue on the other. One is rental count, so I have to buy access for two measures, and I need one dimension here, which I'm going to choose the reserve. So, as you see here in the graph, no, we have the view off. Two measures. Rental accounts are revenue by reserve dimension. This is a way that you can find the pattern different patterns for any influential dimension on any measures. Like As you see here, the revenue, which is the highest in onside sale, is the same as they're in touch out. I mean, in terms off. Max on the list is included in the offside, so it shows that wherever the revenue WAAS highest, their entire account was highest at spot. You can also do the Dubai descending order here as you see descending order by revenue. It shows to you that it's sorted out based on the highest to the lowest, or you can do it the other way around using ascent in order we chose from lowest to the highest. No, let's do more work on this graph. Also, you can check here under the setting. You can show that the label which puts the data on top of each column for you. So you have better and easier visualisation on numbers on the graph knife. We move out reserved on this. Bring another dimension. I want to be in quarter dimension here and I want to do some analysis on my ribbon. You Let's remove the data showed that the labour out from here. So I want to do some analysis on my on my graph and see uncreative threshold and see their my revenue on each quarter. My revenue for everything or any specific criteria was less than 200 k So I can create a filter here. I wanna filter on specific title like all off due to here, and I also want to filter in a specific city. For instance, I can choose Los Angeles, and as you see, we can see the revenue and rental count for this title for all quarter off. 2013 for the City of Los Angeles. So it here. I as I see I have, um, the highest in here a second quarter on the lowest in fourth quarter. As I said, I want to create new lying or a college fish old for to show me the limit I hade and the limit. I want to check the values based on that on the graph. So the Y axis here is the left side. One on the other side is right access. So I choose the left access which, as you see on this column chart is revenue and I want to dry line. You can choose the color as well, or you can also choose dotted or just the streamline and click. OK, so this is my treasured. I want to know any time in the graph that I have anything, any revenue, Oren's account, any revenue because here my chosen character. Yeah, but below 200 I want to look into that and do more analysis. So in here as you see unq warder for quarter it was the lowest on its own border line. So I click on this and I were drilled down into the months and I see here in the four for the fourth quarter. I didn't have anything for October 4 November. I had 54 revenue on for December. I had 100 44 revenue. You get safety's a separate graph for yourself, or you can have it at that higher level. Okay, so if you click on this sign here, you can go back to the higher lover. The original lever that was based on 1/4. If if you remember, when I click on this, if you drill down to mount, this is creating a totally new graph for you on the value here changed from quarter two months. So that's why I said, You can save this as a totally new car for yourself to do analysis, But in here I go back to the higher level again, and I want to do another calculation here. I want to see the difference from that so I can't That gives you only optional calculation . You can apply to the graph. I want to see all the differences in terms off revenue comfort to the previous period. You can choose to show this only at the paragraph or at the corner graph or on both. It's up to you. I choose both. So I click. OK. And here, as you see, in the first quarter, I had 5 50 revenue. In the second quarter, I had 7 50 So I had 200 increase in revenue. And again on the third quarter, I had 7 50 I go from 7 50 to 3 24 so I dropped for 26 in revenue. And in this one I go from 3 24 298 and I dropped 100 26. So this is the highest dropped in revenue. I want to see what happened. What month was the most drop. So I drilled down and again here. I see. For the third quarter, for the month off July I had to 28 revenue on then my riven you dropped in August 2 16 which is 212 drop in revenue. So that's how I can find out what happened in Mondo August's. I can do more analysis based on different dimension or major and find out what was the drop . The reason that it dropped in Marcus and again the same. Here is the difference between these and this one 10. Visualize - Geo Pie chart: Okay, let's create the chart based on geo pie chart. Nall. So this is dichotomy. Call and we create the pie chart based on geographical location. So in here we are bringing revenue from the measures here. So our revenue again, we put it on the size. Go there on then, for dementia. We are bringing country. Let's go back on, which is a higher could higher could dimension will be creating other slight speed went over before So we bring country here and then we bring type here based on the collar And as you see no Here, um, this shows for the whole country off United States, As you see here, all the type off the cities are DVDs or game. Whatever we have in our database, Uh, this is the region. This is the total revenue. So if you click of that since this is a Harkey level again, we can create drill down. So no, it drilled down to ah, reject. As you see. No, this has been changed to region. So if you go through that as you CBC California, it's all California region. So we click on that again real down. I know you see all the subregions on their California. Also, we have sacramental. Uh, we have Allah. Mitya, We have Los Angeles. And if we click on that drill down again, is subregion big? We created based on Selfridge in Los Angeles. Right. So, uh, get on this one. Uh, this is again the any. No, that's the lowest. We cannot go more the real down. But if you do it up again, do you see? No, we see on we go back all the California States. So here again, I can't creating a filter from here. I can choose the city again. Los Angeles It's find the city for me and I apply. I have to see it shows me only for the Los Angeles City from the region. California are probably united a state capture 11. Visualize - Line chart: Now let's create a long chart. So if you click on this graph type line chart on, then you bring your measures like we bring revenue to buy access and then generate two X axis. So, as you see, this creates the line child graph based on the dimension Distin mention on this measure. So it's showing you the type off the movie or cities that's are here action, comedy, drama, family and the amount of revenue that's been created by this months. You can also create a filter on that, and you can filter on any a specific city if you want, or even here you have the option to for other operators, like not in these or equal to or contains Oh, are you can, for instance, choose not in list. So it means give me anything except this one on apply so graphic change all you can go there and change it. You can remove all this on saying that only give me the graph for, like, Honolulu, right click on that, and then you can change the title here as well. Double click like that and then that's your graph. So you see how much is upside down the revenue for this kind of callegary during their on here. You have also the option to beauties on vertical orientation, which means you have your graph here on. Do you have all your data on measures on everything here or on horizontal? When you put in a horizontal, you sit a graph below the page. Great on. If you click on Maximize, you only see the graph. No other majors when you're no other measures when you were working on that. So let's go back to our original and we can know we have this. We save it unless creates a new marriage point charge. So I see, Click on, plus sign on. Then we go to the charts on this sign that you see here is an American point. So this one just copy for you the total number off whatever measures you put here. For instance, if you put revenue here, it gives you the total revenue for all the city's movies or anything that's included in the database. Again, you can go here, actually create a 50 year based on the type off the CD or whatever you have here. For instance, if you choose PS tree here. It gives you the total number of revenue four p. S street for the year for the year 2013. Because your database has only year 2013. Okay, so that's these two graphs. 12. Visualize - Pie chart: in this section. We want to go over creating some pie charts. You can choose any off this kind of chart you want on. Create your visualized analysis. Start with private depth chart. This kind of pie chart has two measures, so you have to think about what measures you want to include here. Let's say we want to include revenue. For one. They put it out size on for the height. We're going to include Target. So we want the revenue on target based on one dimension for dimension. We will choose, generate. So you see, here we have the revenue. Based on general comedy, we have 5558 54 and Target is 1018 56 and here is based on action. The lowest is based on horror. You can click on that and exclude the comedy so you have drama on. As you see, the comedy has bean out, or you can create a filter on this chart. So you want to, for instance, um, create the filter only for kids, and then you see that your chart is only goes with the General Games, which, because that's the only generate that that's on the kids cap kids category. Um, or you can also create filter based on any off these values you want futures type. You can just Truls like the DVD ones and you see Onley. The generates that's associated with DVD is going to be shown here. There are all sort of other kinds off pie chart you can apply on. Also, pie chart is like any other graph. You can apply percentage calculation or even you can apply and tell me. OK, give me the top three Top three a revenue for for this generate because we only have one. Okay, so it gives your top tree, which is comedy action on drama on any other ones. 13. Visualize - Scatter plot: another type of chart, we can create this scatter plot. This type of charts is like animation on gives you some visualization on the pattern. So let's start for one example. So you have the measures which have exam boy access on dimensions. I'm So let's say here the move revenue to the X axis on, then rental price to buy access and then, for the color of you choose, generate again, uh, generated. And then for animation the ad month, As you see here, not the plot is getting created. Okay, so if you click on play, you will see over the month Hadi's rental price on revenue changes based on all these generate. So, as you see, like for instance, action, it's the start of the game. So then we click on that action goes from revenue 10-K 2 20 on, then the same changes for May June July August, under a stuffed amounts 14. Visualize - Predictive Analysis: okay, In this section, we're going to create predictive analysis with the graph. So 40 section we choose discharge discharge, Combine line column line chart on then the measure virtues, which is revenue. So the purpose off this graph is to predict what could be our revenue over the next year or next month. So here we need a dimension that based on that, we create predictive analysis. So here we drag months for the X axis and we wanna see the prediction over the months upcoming months. So if you click on revenue here and choose predictive calculation forecast, it s a P predictive analysis. You see, there are two option. We choose triple exponential smoothing on for the month. We want to sit out over the period of 10 months in the next year. So we click. Um, okay. And as you see here for 2014 for 10 months for 10 month period for 10 periods are 123456789 10. We'll see for the 10 the next 10 period. We have the analysis. That's how it's going to be. The other thing we can also do is on the graph we can put apply rule on here, we would say, Um OK, so if my revenue in any time is less than 140,000 I want that column chart shows red. So we put the rule here. If its revenue is less than 140,000 I want that to be showing as red. Okay, on. We can name this revenue less done for thousands. Or you can call it, um Mini Mom revenue. Okay, so click OK. And as you see here in the graph, no, you see wherever is less than 140,000. Your column chart shows red. You can also choose another rule you can, as I showed you before you can create new reference line here on saying Okay, then why my my value is more than how to $40,000. I want that line. Show me the Tricia for that so you can choose like here, black collar. Say okay on as you see here, it shows the here it shows you the period start like in January. You Verbillo 140,000 in February. Uber bill also desired them quarters to 4/4 on. You will see that here even the line can show you the values that you Pritikin future. You might be below that, er showed that you created. So, as you see here in July is expected that your value will be less than 140,000 in August as well. So that's predictive annals. 15. Compose your story: Now let's compose are a story. We go to the compose room and it gives us options for the frame Levante to use. We call this rental shop story. Have you choose a blank for this one? Quickly. Create. Okay, so this is the component that exists in the Campos room. Let's go over all of them and see what each one does. So if you go to visual ization here, this includes all the graph that you already created in Visualize room before. So all the graph we did go over and create it's all here. The text part can bring you any tax you want to use for your report. Like, for instance, if you want to bring a title here and then you click on this As you see, you see all the text properties here. So if if I want to make this a smaller, let's make this a smaller and we can move it back to here, and we can call it, um graph review and you can change the text off this. As you see on the right panel, you'll see all these options for that. You can change the size too, like 16 which is a little more off the okay and you can, um, make it on the sides. You can also have the option to create background color for this. You can choose like any off this color you want and you can adjust the lens based done your criteria. You better changes to, um, actually use visualization. Okay, You can also have the option to bring pictures here you can at a picture from important from local, which you can go to your local folder and bring our search bodies in database here you can create. You can bring it to them to your A storyboard. You also have input controls that allows you to create different kind of filter on your graph on a play toe. All the graphs inside the storyboard when these are all the dimensions that you have, you can also bring pictograms, which is basically those images in pictograms. You can add it to your story board. You can also, um, have the shapes. The thing that shapes and attacks, which I'm gonna show you later is you can, um you can apply the hyperlink hyperlink on your shapes and your tax. So when you click on it. You can take it to them. Any website on the Internet or toe another page that you have created. So let's start from beginning for a visualization. So in this a storyboard I want to bring the pie chart I created before. So I just drag and put it here. And it I also want to bring them the top five girls margin. Other created before can bring this fun. And I also want to bring the predictive analysis I created before. So I put this at the bottom. You have the option to adjust all this so I can bring this a little more higher, this one as well and make maybe this one a little wider. Nothing between. Also, when you click on any off this, you will see the options here. Um, for your chart title, you can even change that or changed. Changed the legends you can for the for this one. If you select the if you select that you can change the tax, form it off. This makes it the smaller or bigger you have the option to play with it. Here on, um, you can also make this again bigger from this phone as ball can move them and I just them on the page. You make it this morning now, because I want to include input control as well. So I don't want the whole page to be occupied by this graph. But then after I can So here again, on this one, you can change the tax because it has showed the data label you can, As you see, it gives you the data label option. You can do anything you want me that I want to make them a smaller like 10. Um, I cannot just that after I do preview and see what it's good or not, that's for that. You can also bring they put control. So all these graphs I may want to include and bring city. So if I apply city here. So when I add this, the whole graphs will be address that based on the option I choose If you look at this in preview, you will see that all these charts have been added there as you see, So the number the numbers here doesn't look that much good. So you want to address that? You can also see the city has been selected as input control. So we go back to preview again. Let's change some off the text here, which is showing. So as you see, I want to make them even a smaller than I wanna make them eight on. Um, I may. I may not even want to show the data label. Maybe it's too much there. So let's click preview again and see what we see there. Their shows, that label. Okay, now it's gone. It's better. So let's click on preview. Yeah, no is showing better. So we go back there. So here we also can change for the charts. We can also change the color. So if we want to choose any off this color for any off your graph, you can choose your graph and change any color you want Whatever. Who looks better for you. So and also you can change the total background color here, pitch sitting. I want the whole background color to be Maybe this color, whether we're brother, right, it works better for you. It's if these are all just optional. So you can adjust these two now. Okay, So you have all this on your page on city filter is here. So if you click on preview here, you will see that this is your visualization on your page that has been adjusted. So what you can do here, Um if you you notice if you have not the include control city here. So if you want to see that, that are only for a specific city Like for Berkeley. As you see, the whole data changes. So here are your number of comedy rather new. I was 2000 for 68 on your target was 400 aunt here. The top gross margin for those was like 58 32 here. And your revenue. Waas um your target was 45 And you hear that? You see here that that was your predictive analysis because we put a rule that anything below 140,000 would be red. So it's all show you their sign for that. If you change the city now, Teoh another city like to Concord. You see, all this will change again. The number has changed on all the graphs are impacted by this. So you can save that. Um, And after you say that your document has saved. If you go back to preview, let's change the background color for this again. Change it to something, maybe look nicer and more across. Okay, so if you go back to preview here, you can have the desktop preview off this. You can have the tablet preview of heights. This is how it's gonna be looking on. The tablet are also on the mobile, so you have the option to see if you use it. Go to the app in your mobile and you open that This is how it's going to be shown so we can come back to this stop review and go back to the design face again so you can apply any input control. Like, for instance, if you wanna see it in a specific estate, not only city, you have the geography selection here, you open unchanged the region so you can include that on what it does. It's basically when you click preview, not only you can select based on a city, but also you can select based on the state, which here, because your first filter is Concorde, is only showing you that California. So another thing you can add a page here also. Let's true the standard here and we call it tables. Okay, You can have at any graph or anything you want, but I just want to show you how you can go from the graph to table view. So you create that one, it's opens for you, the other template. So I go back to my visualization and I want to bring table here. The cross table I created here, and you can remove all that. These are the options for you. You can bring other graphs or whatever you have. Okay? And I just want to add, um, shape here. I want to add this shape here. Put it here on the reason I'm using this. Just the reason I'm using this because I want to use this as a link. You can also put any tax you want. I want to use this as a link to go back to the original face page. I'm sorry. So, um, here we have this shape, we can I just make it a smaller or bigger if you want. So I want this page. When I select this, it gives him the option. If I want to link that to If I want to apply any action on this So this is the hyperlink, I would say, OK, take me If I click on this, take me to the face first page that was originally created and I click. OK, you can also adjust the collar off the hyperlink or these are the option that's provided to you. So when I click on preview here, let's see if you have the title, we can actually change the title. Um, here, based on whatever you decide to put here, so table view can make it smaller again. All the options are are available When you click and choose anything's a table view here I can I can make it, um, bold on change the font size to, like 16. It's in, my brother were you want to create and then background color You can have so that you what ? Okay. And then you click on preview. As you see Here is your table of you know so no, If I click on this, it takes me to the first page that I created visualization 16. Sharing your story: after you compose your story. Now you can share it with whoever you want, So the option that's available to you depends also on the setting that you have under your five, Preference says. Here we have export as excel, so usually the file you have to include. If you have any filter on your report, you have to include those. Or if you have any hidden dimension, or if there is any dimension that strive from that asset enrichment. So in this example, you can just use export it filter on. Then, after you click on that, it'll export to any as a CSP file or Excel file to any folder local folder that you want to put it locally. The other option is published. Two S A P. Hannah. For this, you need to put on the configuration setting here for all this setting that's required for your server. Instance, user and password, and you are able to connect to a sippy Hannah. The other one is publisher to explore oil again. This is configuration setting. You can if you have a S a P D. I. Platform for Ramiro. You can have the credential here on connect on a publishing in your B I platform or if you have the enterprise platform, are these two options are also available. The other thing is, if you go to fight, preference says, and on their network, you will see the options are here, so depends on what option to choose. Um, if you have proxies setting for if you have a s a p B I platform, you should be able to put it here. And then on the option you will see export Toby I platform or if you have a server specific server for your team or if you have any u r l If you have the euro for a separate cloud, you can also, um, I did this. Also, there's option the new Lumina version. You have option for Hadoop STD fs, which again desired. These are the setting that you have to put here to be able to use that connection on publish it There also on the preferences. We have geo map services that's come with the new version. The A three maps service is automatically there. If you have the license and credential for that, you can enter it and you are able to come to Israel as well. The other thing I would like to mention here if when you have the cloud option here, you will see the option published to a staple cloud, and you can save your story inside the cloud. You go there, you find your file and you have the option off edit mode value or in the cloud so you have the access to visualize and compose room on. You are able to modify it while you are in the cloud and change it on. Also, publish it as public to the power as public. It's a specific u R l, or you can publish it as private Dad, I think, is about about. I wanted to also mention about the extension here. Then you could have gone. It's extension any extension that you add before, Like for instance, here I had a say People w on universe Cory panel. But you can also get other extension from partner that if you click on this, takes you to the website all the extension third party extinction that are available toe Woomera or if you already have the extension and save that under your folder, you can click on manual installation and just bring up your extension on. Be able to use it if you want to add, like Google maps to your charge. If you have the package, you can click on manual installation and install it on. When you go to visualize the room under the map chart, you will be able to see another icon here added for Google maps. 17. Final notes: I hope you enjoy the Lemerre a training session. And, um, I hope I provided you the main things. That about Lumia and functionality off Amira that you need. So I put together a summary for you hear about the links on the version that's available and the one that I used. So the if you are interested toe download a city. You have to goto s appeal Amira website, which is coming from a sippy website. On this is the Ori a link that you can go and download the standard addition for your use. The version I used in my training. Glaus 1.29 country, which is the latest version off Lumiere available as of today on If you want to know what version you have on your desktop, you should go to open your recipe. Lameda, go to the help menu and about a staple Amira, and you will see the version that you have available on your desktop. The windows version I use waas 64 bit version, but they have different version available for 32 US 64. So then you go and downloaded from SNP website. Make sure you download it for the version that's compatible with your Windows version. You can also go to the SNP Lameda Cloud. And, um, if you go to this link, you are able to create account for you. So you are able to publish your story at the end into the cloud and their share it with more public or private as I went through the options which you before the other thing is about the extension. So in your recipe, Lubomira, if you go to file extension on on the extension manager, you have the option to go to the website on upload the third party extensions for different purposes. Like if you want to upload Google map Gala Geo, are any other extension that's available there, too? There are also extension for S a P that if you want to connect your ramiro toe s a P B W two universe or any other extension that you don't have it on your desktop based on your version and capability off your version, you can also down with the firm there or if you have the package already uploaded into your local into your folder, you have the option off manual installation that you can go there and install that extension after you install, you have to restart the mirror to be able to see that extension on their extension manager and use the tour the network for sharing. Ah, when you share your story and publisher story, you have to go on their five preferences and network. And if you have your EL available for certain servers or B i servers or had, do be, are able to does the configuration setting on there that. But, as I said, these are for advance users or B I users consultant that they want to set up this setting for usual, just business users. Depends on what is your the source off your filed. You can just bring a simple excel or even war, file into the Lumiere and create your visualization. So, uh, the sources that are available for you to bring to LEM Iraq Currently this 1.29 version You can't bring attacks you can copy from Clipper. You can connect toe Hanno a real time or a Ziv you not really time you can bring from S a P B. W. You can also bring a universe if you have query with SQL is another option for you. If you want to being acquitted directly from s a PCC, you can also do that. But you have to create your in four set in s a PCC before and then connect through this connection and also toe Hadoop and, um, also two years. Thank you. 18. Lumira Cloud: No. I want to show you how you can share your story and popular down the club. So when you are in shared room, you have the option on published A s, A. P. Lameda cloud. Before doing that, you have to make sure to goto file under preferences and then on their network. You should be able to see this essay pill a miracle out here. As you see, the u R. L is here. Okay, make sure that is set up there on. Then when you come to share room, you click on publish to a scapula mirror club. You type in your credit shot here, and then you publish it on club. Now, I want to show you how you can publish how you can create account on their staple. Amira, this is a U R f or s appeal a miracle out https cloud. That s a palomino dot com. After you come here, you will see s a P can provide you one gigabytes of free storage for your room. Unifies. So click on register new account and put all the information that's been asked to fill in on. Then I agree to the terms on register. After you do that, you are registered with low miracle. Out on the next time you click on log in, you're typing your curtains shows again and you come to the club. There are a couple of options here. Upload. Here you are able to browse on upload any Lamido file that you have on your desktop here you can. Also, you can also can go to create that a set on bringing your excel file or any data source you brought to the stuff. You can also bring it to the cloud on Added here on this shows all the files you have uploaded to the cloud so far, and this one shows only the most that you shared with other people. So when you click on your file, you can share it here. It gives you option to put in the email address off the people. You want to share it with Andi also in the clouds. When you find your file, you can go into the file and you have access to visualize a composer and you're able to do all the anything you used to do on the desta version. You are able to do it here as well on then make it available for others to view