All Activity
This stream autoupdates
 Today

Sadio Sow joined the community
 Last week

Aayush Patni joined the community

Giorgio Mammino joined the community

Etsala joined the community

Raghav Mehta joined the community

Al Gorriaran joined the community
 Earlier

BRandon started following Bach of business information systems student.

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/swinburneuniversityoftechnologybachelorofbusinessinformationsystemsswicisdeg2017 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.

BRandon joined the community

Otgonbayar Baterdene joined the community

Arjun Regmi started following Mr

I have rice mill how to maintain my account


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?

Has anyone had experience with web focus? My company uses it but I want to get switched to Power BI

Pacome started following Historique de power BI

Bonjour je voudrais une petite histoire de microsoft power BI

10 Excel basic formulas and functions to supercharge your reporting skills.
Poonam Kumari Saha replied to Saurabh Jain's topic in Excel Fundamentals
@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. 

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/enus/blog/powerbidesktopjulyfeaturesummary2/ 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/enus/ To learn and practice try https://mva.microsoft.com  Microsoft Virtual Academy https://www.edx.org  Online courses

 business intelligence
 big data
 (and 4 more)

Nandagopal Godhavarma started following Analytics techniques

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.

Saurabh Jain created a club: Advanced R programmers

Saurabh Jain created a club: VBA  Excel Programing

sdpeyton changed their profile photo

45 Analytic Techniques Used by Data Scientists
Saurabh Jain posted a blog entry in Analytics techniques
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 MonteCarlo Simulation Bayesian Statistics Naive Bayes Principal Component Analysis  (PCA) Ensembles Neural Networks Support Vector Machine  (SVM) Nearest Neighbors  (kNN) 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 CrossValidation Model Fitting Relevancy Algorithm * Experimental Design 
hi dear freinds i need a logiciel of simatic step7

Here are 11 basic Excel tricks that will change your life
Saurabh Jain posted a topic in Excel Fundamentals
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 righthand 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 twoletter 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() 
Mutasim Al Ashay changed their profile photo

Rakesh Tripathy changed their profile photo

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

Forecasting: Priciples and Practice http://robjhyndman.com/uwafiles/fppnotes.pdf

Forecasting: Priciples and Practice http://robjhyndman.com/uwafiles/fppnotes.pdf

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

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 reallife 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 5point 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.08e10 *** lnLength 3.4311 0.1330 25.80 1.49e12 ***  Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 Residual standard error: 0.1229 on 13 degrees of freedom Multiple Rsquared: 0.9808, Adjusted Rsquared: 0.9794 Fstatistic: 665.8 on 1 and 13 DF, pvalue: 1.495e12 As we see, besides the aforementioned statistics / measures, summary gives some useful other information as well. We get the values of Rsquare and Adjusted Rsquare. While Rsquare is simply the square of the regression coefficient giving us an idea of the goodness of fit, Adjusted Rsquare 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.

 regression analysis
 simple linear regression

(and 2 more)
Tagged with:

Tricks That Can Make Anyone An Excel Expert
EmilioS replied to Rishav Pandey's topic in Excel Fundamentals
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 
10 Excel basic formulas and functions to supercharge your reporting skills.
EmilioS replied to Saurabh Jain's topic in Excel Fundamentals
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 
حَدَّثَنَا حَجَّاجٌ، قَالَ حَدَّثَنَا شُعْبَةُ، قَالَ أَخْبَرَنِي عَلِيُّ بْنُ مُدْرِكٍ، عَنْ أَبِي زُرْعَةَ، عَنْ جَرِيرٍ، أَنَّ النَّبِيَّ صلى الله عليه وسلم قَالَ لَهُ فِي حَجَّةِ الْوَدَاعِ " اسْتَنْصِتِ النَّاسَ " فَقَالَ " لاَ تَرْجِعُوا بَعْدِي كُفَّارًا يَضْرِبُ بَعْضُكُمْ رِقَابَ بَعْضٍ
Narrated By Jarir : The Prophet said to me during HajjatalWida': 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)."
حضرت جریر رضی اللہ عنہ سے روایت ہےکہ نبیﷺ نے حجۃ الوداع کے موقع پر مجھے فرمایا لوگوں کو خاموش کراؤ (جب لوگ خاموش ہو گئے تو) آپﷺ نے فرمایا: میرے بعد ایک دوسرے کو قتل کر کے کافر نہ بن جانا۔ 
اللھم يافارج الهم ، ياكاشف الغم فرج همى ويسر امرى وارحم ضعفى وقلة حيلتى وارزقنى من حيث لا احتسب يارب العالمين

امام غزالی رح فرماتے ہیں :
جو غلطی کر نہیں سکتا وہ فرشتہ ھے
جو غلطی کرکے اس پر ڈٹ جاۓ وہ شیطان ھے
اور جو غلطی کرکے فورا توبہ کرلے وہ انسان ھے
اور جو توبہ کرکے اس پر قائم رھے وہ الله کا محبوب بندہ ھے.
اللہ ہم سب پر رحم فرمائے۔آمین 
10 Microsoft Excel 2016 Tips Every User Should Know
Rishav Pandey replied to Rishav Pandey's topic in Excel Fundamentals
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 righthand 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. 
10 Microsoft Excel 2016 Tips Every User Should Know
Rishav Pandey replied to Rishav Pandey's topic in Excel Fundamentals
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. 
10 Microsoft Excel 2016 Tips Every User Should Know
Rishav Pandey replied to Rishav Pandey's topic in Excel Fundamentals
8. Create and Manipulate Charts A hallmark feature of Microsoft Excel, creating charts allows you to visually present your wellformed data. Excel makes the process very easy; highlight a range of data in your sheet, select the Insert tab, then click the See all charts button. Click the All charts tab, then browse the through the list of chart styles. You can also hover over a sample to see a preview of what the chart will look like. Once satisfied, click OK to insert the chart into the spreadsheet. If you would prefer to keep it in a separate sheet, select the chart, click Move Chart, select New Sheet then click OK.

Who's Online 0 Members, 0 Anonymous, 18 Guests (See full list)
There are no registered users currently online

Member Statistics

Recent Status Updates

حَدَّثَنَا حَجَّاجٌ، قَالَ حَدَّثَنَا شُعْبَةُ، قَالَ أَخْبَرَنِي عَلِيُّ بْنُ مُدْرِكٍ، عَنْ أَبِي زُرْعَةَ، عَنْ جَرِيرٍ، أَنَّ النَّبِيَّ صلى الله عليه وسلم قَالَ لَهُ فِي حَجَّةِ الْوَدَاعِ " اسْتَنْصِتِ النَّاسَ " فَقَالَ " لاَ تَرْجِعُوا بَعْدِي كُفَّارًا يَضْرِبُ بَعْضُكُمْ رِقَابَ بَعْضٍ· 0 replies
Narrated By Jarir : The Prophet said to me during HajjatalWida': 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

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