Jump to content
Business Intelligence & Analytics Community

All Activity

This stream auto-updates     

  1. Last week
  2. Earlier
  3. Hi there, I'm a 2nd year student in a bachelor of business informstion systems uni degree. Link to the course: https://www.open.edu.au/courses/it/swinburne-university-of-technology-bachelor-of-business-information-systems--swi-cis-deg-2017 I have a couple questions i was hoping someone with experience in the field could help me with. Im stuck between what majors to choose from. I have the option of business analysis and data analytics. Then a choice between a second major between economics and programming. I do have a interest in programming and im new in this field of study with a web/graphic design background. I would love to know anyones thoughts or opinions on the areas i should move into. Thank you in advanced. Brandon.
  4. I have rice mill how to maintain my account
  5. BI on prem

    Has anyone used PowerBI on prem? Cloud won't work for my companies security. Does it essentially work the same as the standard Pro version I'm used to except no cloud?
  6. Web focus

    Has anyone had experience with web focus? My company uses it but I want to get switched to Power BI
  7. @Emilio Regarding use of pivot table Suppose you have your data stored in the form of excel table. Then by inserting pivot table, you can analyse it or create some summary by using table's headers as columns or rows etc in pivot table as per your choice. Further, you can add slicers and use filters to see the pivot table responding to your choices. You can also add a pivot chart based on this.
  8. Microsoft Power BI

    Power BI is strong and efficient combining these features 1. Power Query (Data Cleansing) 2. Power Pivot (Data Modelling) 3. Power View (Data Visualization) 4. Power Maps (Geo Visuals) Download Free desktop version of Microsoft Power BI https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-feature-summary-2/ Note: Every Month it is updated Power BI Web App requires Work or School Account to open and Provides 1 GB of Cloud Space. Also 365 days trial for PRO version and Available for Android / ios Mobiles. https://powerbi.microsoft.com/en-us/ To learn and practice try https://mva.microsoft.com - Microsoft Virtual Academy https://www.edx.org - Online courses
  9. Microsoft Power BI

    Excellent Resource on Microsoft Power BI by Alberto Ferrari and Marco Russo from Microsoft Press Store at Zero Cost https://www.microsoftpressstore.com/store/introducing-power-bi-9781509302284#downloads Power BI book along companion data sets.
  10. Excel VLookUp made easy

    Hello Team, thanks for connecting. I went through your profile and found it very interesting. I have a task on Business Intelligence. Please, would you mind giving me guidance? Thank you.
  11. Hello Everyone! I am very pleased to be a member here. I hope to make friends and offer help to those who are in need of Professional Engineering Services

    Samuel Peyton

    Peyton Engineering Services, LLC

  12. These techniques cover most of what data scientists and related practitioners are using in their daily activities, whether they use solutions offered by a vendor, or whether they design proprietary tools The 45 data science techniques Linear Regression Logistic Regression Jackknife Regression * Density Estimation Confidence Interval Test of Hypotheses Pattern Recognition Clustering - (aka Unsupervised Learning) Supervised Learning Time Series Decision Trees Random Numbers Monte-Carlo Simulation Bayesian Statistics Naive Bayes Principal Component Analysis - (PCA) Ensembles Neural Networks Support Vector Machine - (SVM) Nearest Neighbors - (k-NN) Feature Selection - (aka Variable Reduction) Indexation / Cataloguing * (Geo-) Spatial Modeling Recommendation Engine * Search Engine * Attribution Modeling * Collaborative Filtering * Rule System Linkage Analysis Association Rules Scoring Engine Segmentation Predictive Modeling Graphs Deep Learning Game Theory Imputation Survival Analysis Arbitrage Lift Modeling Yield Optimization Cross-Validation Model Fitting Relevancy Algorithm * Experimental Design
  13. help

    hi dear freinds i need a logiciel of simatic step7
  14. Microsoft Excel is an amazing piece of software, and even regular users might not be getting as much out of it as they can. Improve your Excel efficiency and proficiency with these basic shortcuts and functions that absolutely everyone needs to know. 1. Jump from worksheet to worksheet with Ctrl + PgDn and Ctrl + PgUp 2. Jump to the end of a data range or the next data range with Ctrl + Arrow Of course you can move from cell to cell with arrow keys. But if you want to get around faster, hold down the Ctrl key and hit the arrow keys to get farther: 3. Add the Shift key to select data Ctrl + Shift +Arrow will extend the current selection to the last nonblank cell in that direction: 4. Double click to copy down To copy a formula or value down the length of your data set, you don't need to hold and drag the mouse all the way down. Just double click the tiny box at the bottom right-hand corner of the cell: 5. Use shortcuts to quickly format values For a number with two decimal points, use Ctrl + Shift + !. For dollars use Ctrl + Shift + $. For percentages it's Ctrl + Shift + %. The last two should be pretty easy to remember: 6. Lock cells with F4 When copying formulas in Excel, sometimes you want your input cells to move with your formulas BUT SOMETIMES YOU DON'T. When you want to lock one of your inputs you need to put dollar signs before the column letter and row number. Typing in the dollar signs is insane and a huge waste of time. Instead, after you select your cell, hit F4 to insert the dollar signs and lock the cell. If you continue to hit the F4 key, it will cycle through different options: lock cell, lock row number, lock column letter, no lock. 7. Summarize data with CountIF and SumIF CountIF will count the number of times a value appears in a selected range. The first input is the range of values you want to count in. The second input is the criteria, or particular value, you are looking for. Below we are counting the number of stories in column B written by the selected author: COUNTIF(range,criteria) SumIF will add up values in a range when the value in a corresponding range matches your criteria. Here we want to count the total number of views for each author. Our sum range is different from the range with the authors' names, but the two ranges are the same size. We are adding up the number of views in column E when the author name in column B matches the selected name.  SUMIF(range,criteria,sum range) 8. Pull out the exact data you want with VLOOKUP VLOOKUP looks for a value in the leftmost column of a data range and will return any value to the right of it. Here we have a list of law schools with school rankings in the first column. We want to use VLOOKUP to create a list of the top 5 ranked schools. VLOOKUP(lookup value,data range,column number,type) The first input is the lookup value. Here we use the ranking we want to find. The second input is the data range that contains the values we are looking up in the leftmost column and the information we're trying to get in the columns to the right. The third input is the column number of the value you want to return. We want the school name, and this is in the second column of our data range. The last input tells Excel if you want an exact match or an approximate match. For an exact match write FALSE or 0. 9. Use & to combine text strings Here we have a column of first names and last names. We can create a column with full names by using &. In Excel, & joins together two or more pieces of text. Don't forget to put a space between the names. Your formula will look like this =[First Name]&" "&[Last Name]. You can mix cell references with actual text as long as the text you want to include is surrounded by quotes: 10. Clean up text with LEFT, RIGHT and LEN These text formulas are great for cleaning up data. Here we have state abbreviations combined with state names with a dash in between. We can use the LEFT function to return the state abbreviation. LEFT grabs a specified number of characters from the start of a text string. The first input is the text string. The second input is the number of characters you want. In our case, we want the first two characters: LEFT(text string, number of characters) If you want to pull the names of the states out of this text string you have to use the RIGHT function. RIGHT grabs a number of characters from the right end of a text string. But how many characters on the right do you want? All but three, since the state names all come after the state's two-letter abbreviation and a dash. This is where LEN comes in handy. LEN will count the number of characters or length of the text string. LEN(text string) Now you can use a combination of RIGHT and LEN to pull out the state names. Since we want all but the first three characters, we take the length of our string, subtract 3, and pull that many characters from the right end of the string: RIGHT(text string,number of characters) 11. Generate random values with RAND You can use RAND() function to generate a random value between 0 and 1. D0 not include any inputs, just leave the parentheses empty. New random values will be generated every time the workbook recalculates. You can force it to recalculate by hitting F9. But be careful. It also recalculates when you make other changes to the workbook: RAND()
  15. Berniece

    Hi, I have set up a pivot, the month % and the Rand value difference calculation works. I am trying to add a YTD % which I cannot get right. I have attached an example. Hope someone can assist or put my mind to rest that it cannot be done. Thank you Berniece Pivot Test.xlsx
  16. FREE text : Forecasting

    Forecasting: Priciples and Practice http://robjhyndman.com/uwafiles/fpp-notes.pdf
  17. FREE text : Forecasting

    Forecasting: Priciples and Practice http://robjhyndman.com/uwafiles/fpp-notes.pdf
  18. Excel VLookUp made easy

    Hi Friends, This is my first video tutorial for VLookUp. Hope you all will like it Download the exercise file Vlookup example.xlsx
  19. Simple Regression Analysis in R

    Regression Analysis The basic concept of Regression in Statistics is establishing a cause – effect relationship between two or more variables. The Cause is better referred to as the Independent Variable(s). And the effect is the Dependent Variable. When we regress the dependent variable on the independent one(s) using a regression equation, we obtain a Regression Coefficient which is a measure of the degree of linear association between the cause and the effect. The value of this coefficient always ranges from -1 to +1. A value close to or equal to 1 implies high or perfect positive linear association respectively. Likewise, a value close to or equal to -1 implies high or prefect negative linear association respectively. A value close to or equal to 0 implies little or no linear association respectively. When dealing with real-life data, we resort to Regression Analysis for estimating the relationships among the various variables. It includes a number of modeling techniques to analyze the association between one dependent variable and one or more independent variables (also called Predictors). Here we will deal with some of the techniques that can be employed by the statistical software R in regression analysis. Simple Linear Regression Here, we investigate the relationship between one dependent variable and one independent variable. R provides a number of tools to achieve our objective in this regard. Let us consider an example having the length of the snout vent and weight of alligators as the independent and the dependent variable respectively. Our objective is to determine the degree of linear association between them. First we create a data frame to store the data. Note, that the observations have been transformed to the log scale. R Code: alligator = data.frame( lnLength = c(3.87, 3.61, 4.33, 3.43, 3.81, 3.83, 3.46, 3.76,3.50, 3.58, 4.19, 3.78, 3.71, 3.73, 3.78), lnWeight = c(4.87, 3.93, 6.46, 3.33, 4.38, 4.70, 3.50, 4.50,3.58, 3.64, 5.90, 4.43, 4.38, 4.42, 4.25)) Now, we first perform some exploratory data analysis (graphical analysis) to visually project our data. plot(lnWeight ~ lnLength, data = alligator, xlab = "Snout vent length (inches) on log scale", ylab = "Weight (pounds) on log scale", main = "Figure 1: Alligators in Central Florida") Output: Figure 1.bmp The graph suggests that weight (on the log scale) increases linearly with snout vent length (again on the log scale). Thus, we fit a simple linear regression model to the data and save the fitted model to an object for further analysis: alli.mod1 = lm(lnWeight ~ lnLength, data = alligator) The lm function uses the data stored in alligator and fits a linear model with the weight as the dependent variable with length as the predictor (that is, regressing weight on length). summary(alli.mod1) The summary function gives the 5-point summary of the residuals (estimation error values) as well as the slope and intercept of the best fit regression line that models the data. Output: Call: lm(formula = lnWeight ~ lnLength, data = alligator) Residuals: Min 1Q Median 3Q Max -0.24348 -0.03186 0.03740 0.07727 0.12669 Coefficients: Estimate Std. Error t value Pr(>|t|) (Intercept) -8.4761 0.5007 -16.93 3.08e-10 *** lnLength 3.4311 0.1330 25.80 1.49e-12 *** --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 Residual standard error: 0.1229 on 13 degrees of freedom Multiple R-squared: 0.9808, Adjusted R-squared: 0.9794 F-statistic: 665.8 on 1 and 13 DF, p-value: 1.495e-12 As we see, besides the aforementioned statistics / measures, summary gives some useful other information as well. We get the values of R-square and Adjusted R-square. While R-square is simply the square of the regression coefficient giving us an idea of the goodness of fit, Adjusted R-square also compensates for the number of predictors used in order to avoid overestimation of the strength of association. In this example though, the two values don’t differ much as only one predictor has been used. plot(resid(alli.mod1) ~ fitted(alli.mod1), xlab = "Fitted Values", ylab = "Residuals", main = "Figure 2: Residual Diagnostic Plot") abline(h=0) Now, we use the above code to generate a scatterplot of the Residuals against the Fitted values to check for systematic patterns. Presence of a pattern or trend in the residual plot would indicate a poor fit as the errors are supposed to be randomly distributed about mean 0. Output: Figure 2.bmp The absence of the any definite pattern in the residuals indicates that our model is a good one. In case we do find a pattern, we will require to further tweak our model to provide a better fit.
  20. Tricks That Can Make Anyone An Excel Expert

    Concerning item 14: where do we find the preview area? When cells are formatted with ;;; → the content does not count anymore, so not only invisible, but also uncountable. Is this what we want? I myself make cells invisible by formatting the text color of the selected cells to 'white' , eventually combined with conditional formatting if all cells are formatted. Thank you
  21. Thanks Saurabh, Can you also give some tips and uses of the pivot tables with which you start your post ? That would be most helpful. Thank you Emilio
  22. حَدَّثَنَا حَجَّاجٌ، قَالَ حَدَّثَنَا شُعْبَةُ، قَالَ أَخْبَرَنِي عَلِيُّ بْنُ مُدْرِكٍ، عَنْ أَبِي زُرْعَةَ، عَنْ جَرِيرٍ، أَنَّ النَّبِيَّ صلى الله عليه وسلم قَالَ لَهُ فِي حَجَّةِ الْوَدَاعِ ‏"‏ اسْتَنْصِتِ النَّاسَ ‏"‏ فَقَالَ ‏"‏ لاَ تَرْجِعُوا بَعْدِي كُفَّارًا يَضْرِبُ بَعْضُكُمْ رِقَابَ بَعْضٍ


    Narrated By Jarir : The Prophet said to me during Hajjat-al-Wida': Let the people keep quiet and listen. Then he said (addressing the people), "Do not (become infidels) revert to disbelief after me by striking the necks (cutting the throats) of one another (killing each other)."


    حضرت جریر رضی اللہ عنہ سے روایت ہےکہ نبیﷺ نے حجۃ الوداع کے موقع پر مجھے فرمایا لوگوں کو خاموش کراؤ (جب لوگ خاموش ہو گئے تو) آپﷺ نے فرمایا: میرے بعد ایک دوسرے کو قتل کر کے کافر نہ بن جانا۔

  23. اللھم يافارج الهم ، ياكاشف الغم فرج همى ويسر امرى وارحم ضعفى وقلة حيلتى وارزقنى من حيث لا احتسب يارب العالمين

  24. امام غزالی رح  فرماتے ہیں : 
    جو غلطی کر نہیں سکتا وہ فرشتہ ھے 
    جو غلطی کرکے اس پر ڈٹ جاۓ وہ شیطان ھے 
    اور جو غلطی کرکے فورا توبہ کرلے وہ انسان ھے 
    اور جو توبہ کرکے اس پر قائم رھے وہ الله کا محبوب بندہ ھے.
    اللہ ہم سب پر رحم فرمائے۔آمین

  25. 10 Microsoft Excel 2016 Tips Every User Should Know

    10. Maximize Printing Options when Printing Large Workbooks Spreadsheets work great on large widescreen monitors, but sometimes you might need to print out your workbook. If you are not careful, you can end up wasting a lot of paper on something mostly unreadable. Excel takes care of this using the Backstage printing options, which let you adjust the page size and orientation. Spreadsheets are best printed on legal size paper using landscape orientation. If you need to adjust margins to fit additional information on a single sheet when printing, click the Show Margins button in the right-hand corner of the backstage print tab. You can then use the margins to adjust the columns to fit any data might spill over to another page. If you can’t get all the data on one page, use the Page Setup dialog to make further adjustments. The scaling menu can help you reduce the size of text to help it fit better. Try not to scale too much, since you want to keep text legible You can also use the same dialog to dress up your spreadsheet with a header and footer if desired.
  26. 10 Microsoft Excel 2016 Tips Every User Should Know

    9. Reveal Formulas If you want to validate the calculations in your workbook, revealing your formulas is the way to do it. Select the Formulas tab, then click Show Formulas located in the Formula Auditing group. Now you can easily check through formulas used in your sheet and also print them. It’s a great way to find errors or to simply understand where the numbers come from.
  1. Load more activity
  • Who's Online   0 Members, 0 Anonymous, 9 Guests (See full list)

    There are no registered users currently online

  • Member Statistics

    751
    Total Members
    21
    Most Online
    Wang Jun Kun
    Newest Member
    Wang Jun Kun
    Joined



  • Recent Status Updates

    • sdpeyton

      Hello Everyone! I am very pleased to be a member here. I hope to make friends and offer help to those who are in need of Professional Engineering Services
      Samuel Peyton
      Peyton Engineering Services, LLC
      · 0 replies
    • Asim Siddiq

      حَدَّثَنَا حَجَّاجٌ، قَالَ حَدَّثَنَا شُعْبَةُ، قَالَ أَخْبَرَنِي عَلِيُّ بْنُ مُدْرِكٍ، عَنْ أَبِي زُرْعَةَ، عَنْ جَرِيرٍ، أَنَّ النَّبِيَّ صلى الله عليه وسلم قَالَ لَهُ فِي حَجَّةِ الْوَدَاعِ ‏"‏ اسْتَنْصِتِ النَّاسَ ‏"‏ فَقَالَ ‏"‏ لاَ تَرْجِعُوا بَعْدِي كُفَّارًا يَضْرِبُ بَعْضُكُمْ رِقَابَ بَعْضٍ

      Narrated By Jarir : The Prophet said to me during Hajjat-al-Wida': Let the people keep quiet and listen. Then he said (addressing the people), "Do not (become infidels) revert to disbelief after me by striking the necks (cutting the throats) of one another (killing each other)."

      حضرت جریر رضی اللہ عنہ سے روایت ہےکہ نبیﷺ نے حجۃ الوداع کے موقع پر مجھے فرمایا لوگوں کو خاموش کراؤ (جب لوگ خاموش ہو گئے تو) آپﷺ نے فرمایا: میرے بعد ایک دوسرے کو قتل کر کے کافر نہ بن جانا۔
      · 0 replies
    • Asim Siddiq

      اللھم يافارج الهم ، ياكاشف الغم فرج همى ويسر امرى وارحم ضعفى وقلة حيلتى وارزقنى من حيث لا احتسب يارب العالمين
      · 0 replies
    • Asim Siddiq

      امام غزالی رح  فرماتے ہیں : 
      جو غلطی کر نہیں سکتا وہ فرشتہ ھے 
      جو غلطی کرکے اس پر ڈٹ جاۓ وہ شیطان ھے 
      اور جو غلطی کرکے فورا توبہ کرلے وہ انسان ھے 
      اور جو توبہ کرکے اس پر قائم رھے وہ الله کا محبوب بندہ ھے.
      اللہ ہم سب پر رحم فرمائے۔آمین
      · 0 replies
×